invert a matrix

[DBLONDEL1643728674]

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

[gjeremy1617088143]

Hi , maybe look for tPivot component ?

Send me Love and Kudos

[Anonymous]

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

[DBLONDEL1643728674]

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 ...