How to create a list starting from a matrix

Pietro_Zaza · January 3, 2023, 10:37am

How can i pass from a Matrix a list?
i tryed to use Unpivot node but it didnt works.
any suggestion?

Thanks

aworker · January 3, 2023, 10:45am

It sounds like a job for the -Unpivoting- node:

If you “copy & paste” here the Matrix data in text format, we can provide you directly with the workflow that achieves the transformation.

Hope it helps.

Best
Ael

Pietro_Zaza · January 3, 2023, 10:49am

knime exercise.xlsx (487.9 KB)
here you have it
thanks in advanced for the availability!

aworker · January 3, 2023, 11:12am

@Pietro_Zaza Thanks for the data and my pleasure to help.

The following workflow provides with a possible solution based on the -Unpivoting- node:

And goes from the initial data:

to the following result:

Hope it helps.

Best
Ael