topic Re: invert a matrix in Talend Studio

invert a matrix

DBLONDEL1643728674 — Tue, 13 Apr 2021 15:22:47 GMT

Hello,

I wish to change the axis or invert a matrix ... I do not know how to name what I want to do :

I have a file with 3 columns

and I wish to get

I am looking at different components ... without success until now.

thank you in advance for your help.

regards

Damien

Re: invert a matrix

gjeremy1617088143 — Tue, 13 Apr 2021 15:30:31 GMT

Hi , maybe look for tPivot component ?

Send me Love and Kudos

Re: invert a matrix

Anonymous — Wed, 14 Apr 2021 08:16:41 GMT

Hello,

Could you please take a look at this article about: https://community.talend.com/s/article/Converting-rows-to-columns-Jewx3

Let us know if it is what you are looking for.

Best regards

Sabrina

Re: invert a matrix

DBLONDEL1643728674 — Wed, 14 Apr 2021 14:09:42 GMT

Thank you. I solved the translation with a tPivotToColumnsDelimited.

it look like the attached picture.

Nevertheless, I still have an issue with the "dynamic" columns ... I wish to keep the first line as text/string ... but the content of columns (except column 1) has to be integer ...

With the tPivot component, no scheme is generated ...