Need Logic

[raju4u]

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,

[ray.wurlod]

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

[raju4u]

HI Ray,

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

[chulett]

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.