Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
iq_etl
Premium Member
Posts: 105 Joined: Tue Feb 08, 2011 9:26 am
Post
by iq_etl » Fri May 30, 2014 5:56 pm
Hi all,
I'm wanting to combine rows like this:
row1 key1 keyword1
row2 key1 keyword2
row3 key1 keyword3
row4 key2 keyword1
row5 key2 keyword2
into
row1 key1 keywords (contains keyword1 + keyword2 + keyword3)
row2 key2 keywords (contains keyword1 + keyword2)
It seems that there was a stage for this in the server edition, but I'm not sure what the parallel equivalent is. I've tried searching, but maybe I'm not phrasing the question correctly. Help?
Thanks.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri May 30, 2014 10:12 pm
There is a Server
Row Merger stage and complimentary Row Splitter as well but it doesn't do... this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sun Jun 01, 2014 12:31 am
PXPivot stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sun Jun 01, 2014 8:38 am
With some extra pixie dust thrown in.
-craig
"You can never have too many knives" -- Logan Nine Fingers
verify
Premium Member
Posts: 99 Joined: Sun Mar 30, 2008 8:35 am
Post
by verify » Mon Jun 02, 2014 6:04 am
Use Pivot Stage and select vertical option in it and you can get your required output.
Regards
RK Raju
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Jun 02, 2014 9:28 am
As noted, it will get you close. Afterwards you'd need to handle the "keywords" (plural) field.
-craig
"You can never have too many knives" -- Logan Nine Fingers
iq_etl
Premium Member
Posts: 105 Joined: Tue Feb 08, 2011 9:26 am
Post
by iq_etl » Mon Jun 02, 2014 9:56 am
Thanks! I will give it a try.
iq_etl
Premium Member
Posts: 105 Joined: Tue Feb 08, 2011 9:26 am
Post
by iq_etl » Mon Jun 02, 2014 3:44 pm
Pivot Enterprise + Transformer worked. Thanks again!