Hi All,
I have a scenario to handle. Please suggest approach to design the job.
Input:
Column1 Column 2 Column3
4321 X1 3
4321 X2 4
4321 X3 6
Output Required:
Column1 Column2 Column3 Column4
4321 3 4 6
The source is dynamic where the column2 and column3 can have new values for Column1 indicating the columns output must increase accordingly.
Thanks,
Devi
Rows to Columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My bad. 4am start today, it's now 8:30pm. Yes, it's a vertical pivot. Search DSXchange to find out how to do it. It's been explained many times.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Rows to Columns
use sort stage , there generate change code with cluster or key change , will get 1 for first rows and 0 for duplicates, then use Transfromer stage , there in stage varaible write condition like if change_code=1 then link to new col else concatinate to previous col
hope this helps trywith this
Devi
hope this helps trywith this
Devi
Regards
Sankar
Sankar