To convert the row values to the columns

[uppalapati2003]

Hi All,

i want to change the row values to the values of difrent columns

my source is like

ID Type
1 Clerk
1 Accountant
1 Manger

my taget should be the like this

ID TYPE_Clerk Type_Accountent Type_Manger Type_Gm
1 Clerk Accountant Manger NULL

if any one have any idea please reply back that would be the great

Thanks

[mahadev.v]

Do a search on "Vertical pivot". There is transformer logic as well, in those posts. You would have to customize it for your needs.