How can I genarate multiple rows from a single row

deva · Post by **deva** » Fri Dec 07, 2007 1:59 pm

Hi All,
I have one requirement. I have 3 cols one is cust id,eff.date,no.of.installments.
My question is if custid is 1000 and eff.date is feb/12/2002, and number of installments are 4.
I am looking for the output with 4 rows.
1000 feb/12/2002 4
1000 feb/12/2002 4
1000 feb/12/2002 4
1000 feb/12/2002 4

we are using 7.1/ 7.5 datastage server.

Thanks in advance

swades · Post by **swades** » Fri Dec 07, 2007 2:05 pm

Can you provide more details.

You can do:-

Read installments as source ,and do ODBC look up against same table,using installments as key.

chulett · Post by **chulett** » Fri Dec 07, 2007 2:44 pm

How is this different from your other post?

sreeni · Post by **sreeni** » Tue Dec 11, 2007 12:18 am

Try to use Job activity stage to call your job in Start loop and End loop activity stages in the Job sequencer. Use Start value = 1 , End Value =4.
Then same input record gets inserted into output stage four times.

sreeni · Post by **sreeni** » Tue Dec 11, 2007 12:20 am

Try to use Job activity stage to call your job in Start loop and End loop activity stages in the Job sequencer. Use Start value = 1 , End Value =4.
Then same input record gets inserted into output stage four times.

DSguru2B · Post by **DSguru2B** » Wed Dec 12, 2007 2:48 pm

Write a small routine that takes in the entire record of three columns as a single argument, get the "Installment" count and run a loop equal to the installment count. Within the loop, concatenate the entire record with each other delimited with a line feed. Since you are on windows, it will be Char(013):Char(010).
This way you will feed in one row and get x rows where x is your installment count.