topic Re: How to make a regular and easy transposition (pivot row to columns) in Talend Studio

How to make a regular and easy transposition (pivot row to columns)

citrods — Mon, 11 Jan 2021 09:49:09 GMT

Hello

I need to do an easy task: I don't know why it doesn't work

I I have this kind of excel file:

I want to have this in the end:

No aggregation, nothing coplicated.

Juste transpose row to lines and save it in a new file.

I tried tdenormalize or tPivotToColumnsDelimited. But I don't know how to set the parameters.

Looks like they want me to agregate but I don't want to agregate anything.

Can you help me?

Anonymous — Mon, 11 Jan 2021 11:22:46 GMT

Add another column to the data and set a fixed value to it, this column will be group element on tPivotToColumnsDelimited.

Hope it helps you!

Regards

Shong

citrods — Mon, 11 Jan 2021 19:17:34 GMT

Hello

Thank you, it works!!!

I would like some explanations as i'm a beginner:

I kinda understand why I have to ad a fake ID anf why it used in the group.

what are "Pivot column" and "aggregation column"?

Pivot column, i kinda understand.

I'm not sure about aggregation column.

Maybe my case is too simple for these parameters. Would you have a slightly more complicated case so that I can check how we use those parameters?

thank you

Anonymous — Tue, 12 Jan 2021 03:31:39 GMT

Take a look at the tAggreGateRow component to learn more about aggregation operation. In other complicated cases, it might have more values, like

1;data1;value1

1;data2;value2

2;data1;value3

2;data2;value4

3;data1;value5

3;data2;value6

Regards

Shong