Transpose rows to columns

Six Stars

Transpose rows to columns

Hi All,

 

I'm currently working with excel file as my source data. So is it possible to transpose its rows to a single column.

 

For your reference, I'm attaching the image where rows values for the 1st column would act as the target columns and the values corresponding to each row of the 1st column would act as the values for each of the target column.

Please help me in this regards.

 

Thanks in advance!

 

Regards,

Dipanjan


Accepted Solutions
Twelve Stars

Re: Transpose rows to columns

you can have a look to: http://dwetl.com/2015/07/27/excel-like-transpose-using-talend/
or to
https://stackoverflow.com/questions/36467131/transpose-data-using-talend

Regards

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Community Manager

Re: Transpose rows to columns

Twelve Stars

Re: Transpose rows to columns

you can try to use tnormalize

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Six Stars

Re: Transpose rows to columns

Is it possible that my desired output is of the form as attached in the image?

 

If so could you please suggest an end-to-end flow on that part.

Community Manager

Re: Transpose rows to columns

Yes. Have a look at the link the I provided and give it a try

Six Stars

Re: Transpose rows to columns

Hi @rhall_2_0,

 

I did try your approach, however, I was able to get only the 1st row that is column name in output. And due to which I couldn't proceed further with rest of the data set.

 

Please help me in this regards.

 

Thanks in advance!

Regards,

Dipanjan

Community Manager

Re: Transpose rows to columns

Sorry, I misunderstood what you wanted. This will probably take a bit of Java to do this as you simply want to turn the data on its side. I'm a bit busy right now, but may be able to knock something up a bit later. I assume that you want a CSV output? This is important has your output column types will have to be String in order to suit this.

Six Stars

Re: Transpose rows to columns

Hi @rhall_2_0,

 

It doesn't matter, datatype at the output side can be anything. Though we can always cast that inside tmap.

Right now, the main point of concern for me is to transpose the data up side down.

 

Hope this make sense!

 

Thanks!

Twelve Stars

Re: Transpose rows to columns

you can have a look to: http://dwetl.com/2015/07/27/excel-like-transpose-using-talend/
or to
https://stackoverflow.com/questions/36467131/transpose-data-using-talend

Regards

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: Transpose rows to columns

Tech Blog # Talend - Row to Column Transpose

Hey Guys! We have come up with a detailed blog on Row to Column Transpose in Talend.

Read it here - https://www.learningsutras.net/post/tech-blog-talend-transpose-rows-into-columns

For more blogs on Talend - Join us for FREE or Subscribe to our site www.learningsutras.net

#talend #learningsutras #techblog

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog