You are not logged in.
hello, I have a problem with transforming columns input to rows output.I have an excel file containing 1 row of 30
columns and I would transforming this file to a file containing 1 column of 30 rows(each row value in the output
file is the column name in the source file).
a source table contains 5 columns A,B,C,D,E and no rows(this means 1 row wich represent the columns name).the output file would be contain 1 column named for example 'Date' and its values is A,B,C,D,E(wich the columns name of the source file).
if there is any component or any way to do this help me svp.
have a look at processing componenet normalize & denormalize.
it should help you
Last edited by kzone (2011-03-19 11:27:10)
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
Can anyone share some light on this topic..??
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
where Column_Name is the column_header and the rest are row values in another file.