topic Re: How do I transpose rows into columns ? in Talend Studio

How do I transpose rows into columns ?

Anonymous — Sat, 16 Nov 2024 05:24:03 GMT

Hi,

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!

Re: How do I transpose rows into columns ?

Anonymous — Wed, 03 Jul 2019 15:39:14 GMT

Hi,

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 🙂

Re: How do I transpose rows into columns ?

tnewbie — Wed, 03 Jul 2019 15:49:02 GMT