Multiple rows to single row comma separated values

[priyadarshikunal]

I don't really know the details but here you can trim the output using below code:

Code: Select all

Trim(<value>,',','B')

However in case the record delimiter is set a ',' it should work.

[pravin1581]

Isn't that what you asked for ? Trim the trailing comma.

When I am trying to read that file in a separate job where I can trim that trailing comma, i am able to trim the last comma and getting the desired output but the job throws warning like Missing Record delimiter '''', saw EOF instead, and moreover I wanted to achieve this in a single job instead of 2 jobs.

[ray.wurlod]

So put the "trim the trailing comma" logic into the first job.

[Sainath.Srinivasan]

How do you intend to use this file in the downstream process ?

In the place you read the file, mention record delimiter as 'none' and work with the plan that there is an extra comma. No need to worry about it.

[pravin1581]

So put the "trim the trailing comma" logic into the first job. ...

I am getting the comma separeted values when I am collecting the data in the file in the first job, hence I cannot trim the trailing comma there.

[pravin1581]

How do you intend to use this file in the downstream process ?

In the place you read the file, mention record delimiter as 'none' and work with the plan that there is an extra comma. No need to worry about it.

I have tried all the different options while reading the file in the next job, but it always throws the warning. I am getting the desired output put the warning is bugging me.

[Sainath.Srinivasan]

Did you try 'record delimiter = none' ?

[pravin1581]

Did you try 'record delimiter = none' ?

Tried out all the options but cannot get rid of the warning.

[anbu]

Can you post the warning message?

[victor236]

Read the source and write an output with record delimiter as comma

Thanks Sai. I tried this , the output is coming as 1,2,3,4,

Hi Pravin,

I am looking at this thread which seems to be important and may be useful any time.

Can you tell me how did you try this, did you try this with the pivot stage?
I am using Server job on windows server where I could not get the result what you posted. Just seeking some help to try this.

[UAUITSBI]

Or even in a simpler way, create a stage variable like this:

sv1 = sv1 : ',' : InputColumn

and map it to the target column derivation.

The last output row will have all the values...

This doesn't works . The output is coming as 0,0,0,0,

Hi,
Can you tell me how did you define your Stage Variable exactly?I am getting the same result with 0's in output column

[reachmexyz]

Try unix commad
paster -s -d, source_file > Target_file

[Phani01]

So Pravin, What was the logic you implemented.

Could you please let us know.

[marpadga18]

Read the source and write an output with record delimiter as comma

Thanks Sai. I tried this , the output is coming as 1,2,3,4,

Hi could you tell me how you did you get it? I have same thing to do.
I did with stage variable logic but it is giving
0
0
0
0
could you corrcet me where I am doing worng?
Thanks M

[marpadga18]

This doesn't works . The output is coming as 0,0,0,0,

This should work. May be try defining the initial value of your stage variable to '' {Empty}

If you are mapping the column properly, how come this doesnt work? No complex thing involved in this. You are just appending your column to the stage variable. I have did this before and it worked. All you need to do is to check if everything is setup properly.

Hi Arun I did this but I am also getting 0,0,0,0,0, data is not comming. I tried your data as example could you tell me were I am doing wrong?

sv1 = sv1 : ',' : Inputcolumn