Hi
I've got this kind of data table (Excel or csv):
name joe peter Kelly
surname smith warton hartford
age 23 28 34
occupation professor bartender manager
and I want to use the first column as names for my table fields like this:
name surname age occupation
joe smith 23 professor
peter warton 28 bartender
kelly hartford 34 manager
I've used several components but to no avail. Take into account I don't need aggregation whatsoever, just transpose and convert rows to columns using first column as header.
Hi,
This is a custom component developed by our community user and shared on Talend Exchange, you can download it from Talend Exchange freely, read the below link to learn how to install custom component into Talend Studio.
TalendHelpCenter:Installing a custom component.
So far, there is no a proper talend component for your requirement.
Best regards
Sabrina
Hi,
This component is old, it is not compatible with the new releases of Talend Studio, and mlange do not update it!
To get this component work with the new releases of Talend Studio, you have to modify two places.
1. Modify the tTurnRow_java.xml file, add the family element, for example:
<FAMILIES>
<FAMILY>Processing</FAMILY>
</FAMILIES>
<DOCUMENTATION>
<URL/>
</DOCUMENTATION>
2. Modify the tTurnRow_messages.properties file, remove this line from the file:
FAMILY=Processing
Feel free let me know if it is OK with you.
Best regards
Sabrina
