topic Re: How to transpose Rows to Columns in Excel? in Talend Studio

How to transpose Rows to Columns in Excel?

Anonymous — Sat, 16 Nov 2024 08:58:58 GMT

Hi everyone,

I'm trying to transpose Rows to Columns of an Excel file.

Input:

Articoli	561	575
Video	1049	1161
Tot	1610	1736

Expected Output:

Articoli	Video	Tot
561	1049	1610
575	1161	1736

I tried unsuccessfully using tUnpivotRow, tNormalize, tDenormalize, tPivotToColumnsDelimited components.

Is it possible to achieve this output?

If yes, how?

Best regards,

Giacomo

Re: How to transpose Rows to Columns in Excel?

TRF — Mon, 04 Dec 2017 11:30:50 GMT

Hi,

Here is a solution https://community.talend.com/t5/Migration-Configuration-and/Converting-rows-to-columns/ta-p/21667

Hope this helps.

Re: How to transpose Rows to Columns in Excel?

Anonymous — Mon, 04 Dec 2017 16:42:47 GMT

Hey,

Would be easier if you included headings for your columns,
c1 c2 c3
Articoli 561 575
Video 1049 1161
Tot 1610 1736

I have used tPivotToColumnsDelimited that did exactly what you want, but it did take some tweaking for it to work properly.

The Pivot Column field should be c1, your Aggregate column would be c2.

That might work.

Goodluck!

Re: How to transpose Rows to Columns in Excel?

Anonymous — Mon, 04 Dec 2017 17:42:13 GMT

And what should I put as "Group by" columns?

And for "Aggregating functions"?

Thank's for the answer,

Giacomo

Re: How to transpose Rows to Columns in Excel?

TRF — Mon, 04 Dec 2017 18:00:08 GMT

The same as in the link should work.
Articoli for the "Group By", First for the Fonction.

Re: How to transpose Rows to Columns in Excel?

Anonymous — Tue, 05 Dec 2017 08:58:34 GMT

Hello everyone,

unfortunately none of the solutions above worked.

By the way I found a custom component, tTranspose

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F187&pi=marketplace%252F1%252Fproducts%252F187%252Fitems%252F246

This component works fine for the issue that I described.

Thank you all for the answers,

Giacomo

Re: How to transpose Rows to Columns in Excel?

Anonymous — Wed, 06 Dec 2017 02:43:41 GMT

Hello Giacomo,

Thank for sharing your solution on forum and marked it as accepted.

Best regards

Sabrina

Re: How to transpose Rows to Columns in Excel?

Anonymous — Tue, 23 Jul 2019 14:39:57 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