topic Transposed with multiple agregation column in Data Quality

Transposed with multiple agregation column

JohnBog2023 — Fri, 15 Nov 2024 22:02:18 GMT

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?

Re: Transposed with multiple agregation column

Anonymous — Mon, 06 Mar 2023 08:23:47 GMT

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

Re: Transposed with multiple agregation column

JohnBog2023 — Mon, 06 Mar 2023 12:09:15 GMT

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.

Re: Transposed with multiple agregation column

michael254 — Mon, 24 Apr 2023 09:22:50 GMT

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:

Connect your input table to the tPivotToColumns component.
In the "Group By" section, select the "id" column and all the columns that you want to use as row headers (i.e., "date" and "category").
In the "Aggregations" section, add the "value" column and select "sum" as the aggregation function. Then, add the "value2" column and select "max" as the aggregation function.
In the "Advanced Settings" section, select "Generate key column" and specify a name for the key column (e.g., "key").
Click on "Preview" to verify that the output is as expected.
If the output is correct, you can connect the tPivotToColumns component to your output destination.

The resulting output should be similar to the one you provided.

I hope this helps! www.mywafflehouse.com