how to split single row of input into 2 output rows

Prabhakar · Post by **Prabhakar** » Mon Apr 02, 2007 7:41 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 02, 2007 10:26 pm

You may as well use a server job - this whole thing is going to be sequential in any case.
Construct rows in a Transformer stage that contain the requisite data and newline character. Write to target sequential file as a single VarChar column with no field delimiters.