topic Re: Convert Columns to Rows using tUnpivotRow in Talend Studio

Convert Columns to Rows using tUnpivotRow

Anonymous — Tue, 30 Jul 2013 10:03:37 GMT

I need to covert the column to rows from excel file. For which i have downloaded tUnpivotRow component and added in TOS preferences. But i couldnt see that component in Talend palette. Is there way to convert the columns to rows is possible. I m using Talend Version: 5.3.0. Need help.
Thanks

Re: Convert Columns to Rows using tUnpivotRow

Anonymous — Tue, 30 Jul 2013 10:21:14 GMT

Hi,
Did you follow the steps mentioned in TalendHelpCenter:Installing a custom component to install the custom tUnpivotRow component?
Best regards
Sabrina

Re: Convert Columns to Rows using tUnpivotRow

Anonymous — Wed, 31 Jul 2013 10:25:09 GMT

Yes. Follwed the same steps. Donwloaded the zip file and extracted the files into a folder and given that path in user component folder. Do i have to follow any naming convention for the folder name which is assigned to user component folder?

Re: Convert Columns to Rows using tUnpivotRow

Anonymous — Wed, 31 Jul 2013 10:29:27 GMT

Hi,

Do i have to follow any naming convention for the folder name which is assigned to user component folder?

Did you change the name of it? You'd better follow the naming convention for the folder name which is assigned to user component folder. No any change in it.
Best regards
Sabrina

Re: Convert Columns to Rows using tUnpivotRow

Anonymous — Fri, 19 Jun 2015 21:36:29 GMT

Hello Talend Team!
I have been trying to find a way to convert column headers in the input to different column headers at the output. For example:
I have
Source: Target
Col001 Col002 Col003... Transaction_Code Customer_Name Customer_Last_Name
Value1 Value2 Value3... Value1 Value2 Value3
The source is a table. The target is a file. The target headers are in an table with their corresponding original column numbers in rows:
1 col001 Transaction_Code
2 col002 Customer_Name
3 col003 Customer_Last_Name
.
Any advice on how to tackle this problem is welcomed.