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.
Thanks in advance!
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.
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks