need logic

[dstest]

I have 6 columns in my file.

ID,CODE1,CODE2,CODE3,CODE4,CODE5
123,300,200,500,600,20
123,400,40,30,300,20

I need the output like below

ID,CODE1,CODE2,CODE3,CODE4,CODE5
123,300,200,500,600,20,400,40,30,300,20

Can any one have any idead about how to do this in datatsage

Thanks

[paddu]

I need the output like below

ID,CODE1,CODE2,CODE3,CODE4,CODE5
123,300,200,500,600,20,400,40,30,300,20

How many output columns you have ???

[kcbland]

Seems like sorting and stage variables will do the trick.

[ray.wurlod]

You have more columns than column headings in your desired output. Please be more precise about the specification of your requirement.

[htrisakti3]

if I can infer by your example, you want to concatenate lines that have same ID.

Here's how i'd do it:
1. read all fields into 1 long varchar --> file1
2. using Field() read out ID, & write to hashedfile HF_id (ID, str1)
3. in another job, src=file1 ; lookup: HF_id ; out=HF_id (key=ID)
in Tfm, if ID match found --> concatenate existing value of HF_id.str1

try out & let us know..

[htrisakti3]

if I can infer by your example, you want to concatenate lines that have same ID.

Here's how i'd do it:
1. read all fields into 1 long varchar --> file1
2. using Field() read out ID, & write to hashedfile HF_id (ID, str1)
3. in another job, src=file1 ; lookup: HF_id ; out=HF_id (key=ID)
in Tfm, if ID match found --> concatenate existing value of HF_id.str1

try out & let us know..

sorry i meant to say that use Server job to reconstruct the file..

[dhanashreepanse]

You can also try this with a PX job:
1. Sort the input based on the ID column and generate Rank_Num starting from 1 wherever the ID changes.
2. Use a filter stage and have 2 outputs from it. First one filters outs all rows with Rank_Num=1 and second one filters out all rows with Rank_Num<>1.
3. Use a Join stage with a Left outer condition. Left link would be the row with Rank_Num=1. Take the required columns from the other rows on the right link.

Let us know if this works.

Regards,
Dhanashree

[ray.wurlod]

Why are you all wasting your time guessing the requirement? Why not wait until dstest posts the precise requirement, as asked?