I Want Output in the following format

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
busicnu@gmail.com
Participant
Posts: 3
Joined: Wed Dec 04, 2013 5:15 am
Location: Hyderabad

I Want Output in the following format

Post by busicnu@gmail.com »

My source file is sequential file,in sequential file record is a,b,c,d,1,2,3.
The expected output is
abcd,1
abcd,2
abcd,3
Top
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Concatenate the first four fields then pivot.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

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