Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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