Data transforming -

Dear all,

I guess I have a very easy task but unfortunately I stuggel to get the data transformed like I need to.

The left hand side is the current data format and I want to get the data in the left hand
Which data manipulation is needed?

Thanks in advance and best regards,

Hi @Vaze and welcome to the Knime Community.

This would be a data manipulation involving Pivot.

Input data (same as yours):
image

After pivoting:
image

Workflow looks like this:
image

And here’s the workflow: Data transforming - vertical to horizontal.knwf (7.2 KB)

2 Likes

Thanks for that!

But how can I integrate my xls file into the Table Creator? Sorry for the stupid questions

Best regards

Hi @Vaze , the Table Creator is just a way to manually input data.

You can just use an Excel Reader instead of the Table Creator since you have the data in Excel, or if you already have a workflow that’s reading the Excel file, you just need to use the Pivoting node with your workflow.

My workflow is just meant as an example to help you see how the Pivoting node was configured based on the Table Creator.

2 Likes

Thank you so much

It worked out

1 Like

No problem @Vaze , happy to help

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.