Hello,

I have the exact requirement as mentioned by the thread starter. But nothing is working, as in, I have tried tDenormalize, tUnpivotRow, tSplitRow. I have to fetch the column headers i.e A,B,C,D,E and store these as row values
New_Col
A
B
C
D
E

Can anyone share some light on this topic..??

Regards,
Lilth

Hi Pedro,

Here is my sample data:

product_class    product    brand_name_place    product_name_type
30    1    Washington    Washington Berry Juice
52    2    Washington    Washington Mango Drink
52    3    Washington    Washington Strawberry Drink
19    4    Washington    Washington Cream Soda

My column headers are product_class, product, brand_name_place and product_name_type.

I need to store these as
Column_Name
product_class
product
brand_name_place
product_name_type

where Column_Name is the column_header and the rest are row values in another file.

Regards,
Lilth

That works..!!

Thanks a lot Pedro, this was what I was actually looking for.

Regards,
Lilth