Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, I have the next table information like input:
And I need to generate the following result
I tried tried with tPivotToColumnsDelimited
, but only allows one agregation columns.
Any idea?
Hello,
Could you please take a look at this KB article about:
https://community.talend.com/s/article/Converting-rows-to-columns-Jewx3
Feel free to let us know if it is what you are looking for.
Best regards
Sabrina
Hi xdshi, thanks for your answer, but i looking for manage multiple agregation columns, in the example "total groups" and "total students". The tPivotToColumnsDelimited only have one agregation column. In the example i put 2 , but in the real case i have more than 10 variables.
Hello,
I would like to suggest you here
It looks like you are trying to perform a pivot operation on the given table to obtain the desired output. However, since you want to aggregate multiple columns, the tPivotToColumnsDelimited component may not be sufficient.
You can use the tPivotToColumns component instead, which allows you to specify multiple aggregation columns. Here's how you can do it:
The resulting output should be similar to the one you provided.
I hope this helps! www.mywafflehouse.com