Hi, guys. I need help with aggregating a table. I created a YouTube video that explains what I need done.
Hi @cageybee,
thank you for creating this little youtube video. Made it really easy to understand your goal
I created a little example workflow for you: https://kni.me/w/8qsV14wWm3anQAqF
The idea is to use the GroupBy node to calculate the aggregated values. Next, I extract only the values from the diagonal, as these are the values you are interested in, using an Unpivoting and an Rule-based Row Filter node. To make it work it is important to use the setting option Keep original name(s) for the Column Names in the GroupBy node.
Lastly I add the information to the original table using a Joiner node.
Please let me know in case you have any questions regarding the example workflow.
Best
Kathrin
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.