How Pivot Stage works in Server Edition of Datastage 11.5

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Venkat_Jax
Premium Member
Premium Member
Posts: 2
Joined: Thu Jul 09, 2015 8:19 am

How Pivot Stage works in Server Edition of Datastage 11.5

Post 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.
just4u_sharath
Premium Member
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.

Post by just4u_sharath »

You can do this by defining stage variables, sorting the data on the key column and concatenate the 2nd column
Venkat_Jax
Premium Member
Premium Member
Posts: 2
Joined: Thu Jul 09, 2015 8:19 am

Re: How Pivot Stage works in Server Edition of Datastage 11.

Post 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.
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Re: How Pivot Stage works in Server Edition of Datastage 11.

Post 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'sPivot stage pivots horizontal data.
If this requirement must be met using a Server job, then see these two posts.
Post Reply