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

[citrods]

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]

Hi

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]

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]

Hi

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