How do I transpose rows into columns ?

Four Stars

How do I transpose rows into columns ?

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!

Employee

Re: How do I transpose rows into columns ?

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 :-)

Seven Stars

Re: How do I transpose rows into columns ?

denormalize.png

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now