Page 1 of 1
How Pivot Stage works in Server Edition of Datastage 11.5
Posted: Thu Feb 22, 2018 1:36 pm
by Venkat_Jax
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.
Re: How Pivot Stage works in Server Edition of Datastage 11.
Posted: Thu Feb 22, 2018 2:30 pm
by just4u_sharath
You can do this by defining stage variables, sorting the data on the key column and concatenate the 2nd column
Re: How Pivot Stage works in Server Edition of Datastage 11.
Posted: Thu Feb 22, 2018 3:10 pm
by Venkat_Jax
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.
Posted: Thu Feb 22, 2018 6:18 pm
by rkashyap
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.
Requirement is to perform "Vertical Pivot" and Server job's
Pivot stage pivots horizontal data.
If this requirement must be met using a Server job, then see these
two posts.