DSXchange

Posted: **Tue Feb 21, 2012 6:22 am**

Hi All,

I have a scenario like this,

source is coming like,

id , Dept , value
----------- --------- ------
|10|13|15| , abc , 15

Desired output is,

id , Dept , value
----------- --------- ------
10 , abc , 15
13 , abc , 15
15 , abc , 15

Can anyone please explain the transformer loop logic for Datastage 7.5

Thanks in advance

Regards,
Thiru

Posted: **Tue Feb 21, 2012 7:40 am**

There is no 'loop logic' in 7.5, you'll need at least 8.5 for that. Search here for horizontal pivot for thoughts on how to handle your issue.

Posted: **Tue Feb 21, 2012 9:45 am**

can you please tell me the logic in 8.5?

Posted: **Tue Feb 21, 2012 11:07 am**

Count the number of delimiters, set that number as your counter in the loop and duplicate the rest with a new line character between your rows.

DSXchange

tansformer logic in transformer for Data stage 7.5

tansformer logic in transformer for Data stage 7.5