topic Re: Transpose rows to columns in Talend Studio

Transpose rows to columns

dipanjan93 — Sat, 16 Nov 2024 07:36:45 GMT

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

Re: Transpose rows to columns

Anonymous — Fri, 21 Sep 2018 13:56:04 GMT

Take a look here: https://community.talend.com/t5/Migration-Configuration-and/Converting-rows-to-columns/ta-p/21667

Re: Transpose rows to columns

fdenis — Fri, 21 Sep 2018 14:09:11 GMT

you can try to use tnormalize

Re: Transpose rows to columns

dipanjan93 — Mon, 24 Sep 2018 05:32:42 GMT

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.

TrasposedSourceData.JPG

Re: Transpose rows to columns

Anonymous — Mon, 24 Sep 2018 09:12:26 GMT

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

Re: Transpose rows to columns

dipanjan93 — Mon, 24 Sep 2018 11:49:34 GMT

Hi @rhall,

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

Re: Transpose rows to columns

Anonymous — Mon, 24 Sep 2018 13:17:21 GMT

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.

Re: Transpose rows to columns

dipanjan93 — Mon, 24 Sep 2018 13:43:05 GMT

Hi @rhall,

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!

Re: Transpose rows to columns

fdenis — Mon, 24 Sep 2018 13:48:06 GMT

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

Re: Transpose rows to columns

Anonymous — Tue, 23 Jul 2019 14:35:50 GMT

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