DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Venkat_Jax



Group memberships:
Premium Members

Joined: 09 Jul 2015
Posts: 2

Points: 15

Post Posted: Thu Feb 22, 2018 1:36 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
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



Group memberships:
Premium Members

Joined: 01 Apr 2007
Posts: 236
Location: Michigan
Points: 2022

Post Posted: Thu Feb 22, 2018 2:30 pm Reply with quote    Back to top    

You can do this by defining stage variables, sorting the data on the key column and concatenate the 2nd column
Rate this response:  
Not yet rated
Venkat_Jax



Group memberships:
Premium Members

Joined: 09 Jul 2015
Posts: 2

Points: 15

Post Posted: Thu Feb 22, 2018 3:10 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
rkashyap



Group memberships:
Premium Members

Joined: 02 Dec 2011
Posts: 518
Location: Richmond VA
Points: 4664

Post Posted: Thu Feb 22, 2018 6:18 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours