Transformation Problem

[Jacko]

Hi all,
I have a tricky problem related to Data Transformation.
In Picture 1 you can see the original data and in Picture 2 how the data should look like after running the workflow.
Original data has the problem, that for every new ‘Explanation’ in the same Time, a new row was created. But for a specific time there should be only one row (with columns added for each ‘Explanation’.
Is there an option to solve that problem with KNIME? I’m happy for every hin for the solution. You can use the example data if you want. Thanks!

Example.xlsx (9.8 KB)
Picture 1:

Picture 2:

[izaychik63]

Group By node will help to solve your task. Use a List as aggregation. Then split list column with Cell Splitter.

[Jacko]

Thanks for the reply. That sounds logical. But how are the preferences in the node, that there is the list of explanations for one specific time?

[mlauber71]

It would look like this

kn_example_transformation_time.knwf (24.3 KB)

[Jacko]

Thanks a lot that helped! Didn’t know that you can combine ‘Groups’ with ‘manual aggregation’ in GroupBy node.