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
How can I genarate multiple rows from a single row
Moderators: chulett, rschirm, roy
How is this different from your other post? ![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
This way you will feed in one row and get x rows where x is your installment count.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.