tansformer logic in transformer for Data stage 7.5

[thirupathireddy.gankidi]

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

[chulett]

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.

[thirupathireddy.gankidi]

can you please tell me the logic in 8.5?

[DSguru2B]

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.