Hi, guys. I need help with aggregating a table. I created a YouTube video that explains what I need done.
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.
this is my solution. Enjoy.
play_ground.knwf (737.0 KB)
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.