how to split single row of input into 2 output rows

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
Prabhakar
Participant
Posts: 10
Joined: Mon Apr 02, 2007 6:28 pm
Location: Melbourne

how to split single row of input into 2 output rows

Post by Prabhakar »

Hi Gurus,

I am having a problem in spliting a single row of records in to 2 output rows

eg:
Input:
cust id Name Lastname age
1 Prab raj 23
2 sam rob 24

output:
Custid Name Lastname
Custid age
1 Prab Raj
1 23
2 Sam rob
2 24


Can any one suggest me which stage to choose to do this function
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

How is this any different than your other post in the Server forum? Hint: nothing. Granted, you should have started here, but let's not start all over again here. :evil:

Folks, if you feel the need to contribute to this thread, please do so in the linked post, not here. Or at least check it first. :roll:
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Oh, and please delete the duplicate post in this forum before someone replies to it.
-craig

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