Hi, I'm trying to convert multiple rows into one row. I can see the Pivot stage in Processing Palette, but I don't see the properties of Pivot stage other than Input and Output. My data looks like this
Number Code
33590 BL
33590 TL
33590 DL
Output expected
33590 BL,TL,DL
Any help is appreciated.
How Pivot Stage works in Server Edition of Datastage 11.5
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 2
- Joined: Thu Jul 09, 2015 8:19 am
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Re: How Pivot Stage works in Server Edition of Datastage 11.
You can do this by defining stage variables, sorting the data on the key column and concatenate the 2nd column
-
- Premium Member
- Posts: 2
- Joined: Thu Jul 09, 2015 8:19 am
Re: How Pivot Stage works in Server Edition of Datastage 11.
Thank you for your response Sharath. How do you connect the stage variable to the sort stage. Also can you please explain more on concatenation of 2nd column.
Re: How Pivot Stage works in Server Edition of Datastage 11.
Requirement is to perform "Vertical Pivot" and Server job'sPivot stage pivots horizontal data.Venkat_Jax wrote:I'm trying to convert multiple rows into one row. I can see the Pivot stage in Processing Palette, but I don't see the properties of Pivot stage other than Input and Output.
If this requirement must be met using a Server job, then see these two posts.