concatenate row values into one column based on keys

[new_ds_man]

<>

[bhasds]

Hi New_ds_man,

It is a vetical pivot-

Code: Select all

1 If col1 <> SV2 Then col3 Else SV1 :",": col3     SV1

2. col1  SV2(initialize with "")

3. In derivation of col3 take the output of SV1.

4.Use a remove duplicate stage after transformer to retain the last duplicate record in the group.

[new_ds_man]

Thanks much BHASDS. I now have the result based on your solution. Really appreciate your time and help.

[chulett]

Why in the heck did you feel the need to go back and remove your original question after it was answered? That's a pretty crappy thing to do.