Converting from rows to Columns

[Sandeepch19]

HI,

I need to convert from rows to column inorder to create derive columns
for eq:
ID NAME ATTR_NAME ATTR_VALUE

12521 GENERAL TEMPLATE NAME V
12521 GENERAL RF ZONE TBD

Output should be
ID TEMPLATE NAME RF ZONE
12521 V TBD
Please let me know how to do this using stage variable.. or any other method is there for this..

Thank you

[chulett]

An exact search here for 'vertical pivot' will turn up your options. In Server, a hashed file can make this process pretty simple as well.

[Sandeepch19]

Thanks Craig, i have used a logic which will compare current id and previous id and also i have used hash file to produce the output...it's working now..

but my concern is i have 43 derived columns like this...does this slow down the performance.. if so could you give me the tips to counter that..

[ray.wurlod]

Everything additional you do must necessarily degrade performance. Do only that which you must do.