Data Format Transformation [Transpose Work Flow]

Hello,

I have been struggling for quite some time now with the task below so any help from the community would be really appreciated.

I have an input table in the following format and I would like to transform it to the output format shown after:

INPUT

OUTPUT

I am a still learning Knime but I tried implementing a workflow using chunk loops and transpose nodes but the problem is that I can’t predict in how many locations would each product appear [to configure the chunk loop].

Any help would be really appreciated.

Thanks a lot.

Input and Output sample files are attached.
Input.xlsx (9.8 KB)
Output.xlsx (10.0 KB)

You can try Group Loop where location will be a part of grouping criteria.

I was able to achieve what I wanted by using just one node (unpivoting) using the (Product, Location) as retained columns and the rest as value columns.

4 Likes

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