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)