concatenate row values into one column based on keys
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Tue Jul 08, 2008 1:12 pm
concatenate row values into one column based on keys
<>
Last edited by new_ds_man on Thu Oct 25, 2012 2:21 pm, edited 1 time in total.
Hi New_ds_man,
It is a vetical pivot-
4.Use a remove duplicate stage after transformer to retain the last duplicate record in the group.
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.
-
- Participant
- Posts: 18
- Joined: Tue Jul 08, 2008 1:12 pm