I'm using Talend Big Data Platform 7.1 and I need to convert rows into columns. Basically I have only 1 record (row) and 62 columns. Going forward I need to add two columns named field_name and field_value. field_name will contain the column names and field_value will have the data or record. After transposing, I should have 62 rows and 2 columns.
If you are looking for Pivot, there is a component called tPivotToColumnsDelimited in Standard job but its not available in Bigdata job. So you can try to do this task in a Standard job and orchestrate your Standard and Big data jobs accordingly in the scheduler.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
