joining multiple records to one record

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

Post Reply
RAJEEV KATTA
Participant
Posts: 103
Joined: Wed Jul 06, 2005 12:29 am

joining multiple records to one record

Post by RAJEEV KATTA »

I have the data in the below format

empno(field name)
7369
8765
9008
4507

I want it in this format
empno(field name)
7369|8765|9008|4507

how do we merge multiple records into one record as pivot does only horizontal in parallel jobs.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Why, you search the forums for "vertical pivot" of course!
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”