Page 1 of 1
concatenate row values into one column based on keys
Posted: Thu Oct 25, 2012 12:12 pm
by new_ds_man
<>
Posted: Thu Oct 25, 2012 1:36 pm
by 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.
Posted: Thu Oct 25, 2012 1:51 pm
by new_ds_man
Thanks much BHASDS. I now have the result based on your solution. Really appreciate your time and help.
Posted: Thu Oct 25, 2012 3:59 pm
by 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.