DSXchange

Hi All,

My input is like
1,gg,3
2,hh,2
3,hh,1

3rd column name is value an my output should display according to the value of that colmn.


here o/p i slike
1,gg,3
1,gg,3
1,gg,3
2,hh,2
2,hh,2
3,hh,1

Can anybody help me the logic for the above.

Thanks,

Use the looping construct in the version 8.5 Transformer stage. It's an ideal usage for this functionality.

HI Ray,

Thanks for the information ,cant we do in the 8.1 version.Please let me know any work around.

I would look into setting up the data so you could then perform a horizontal pivot. For example:

1,gg,3 -> 1,gg,3,gg,3,gg,3
2,hh,2 -> 2,hh,2,hh,2

Set up the max number of columns and then pivot the result.