Conversion of Data from Rows to columns

[Subramanyam]

Hi Team,

I would like to transpose only two columns from the data extracted from excel sheet.

attaching the data and the output data screenshot.

Please help me in designing the knime workflow.

Attaching the input file

output screenshot:

[Subramanyam]

attaching input file

Template for IM India.xlsx (22.0 KB)

[ActionAndi]

Hi,

you can try the unpivot node which does exactly the operation you need:

Unpivot – KNIME Community Hub

Best,
Andreas

[Subramanyam]

I have tried the same but I couldn’t get the same. May be I am missing something in applying the unpivot node.

Could you please apply it on the attached data?

[ActionAndi]

Hi,

The settings in the “unpivot node” are pretty straight forward:

Here’s the link to the worflow in my Community Hub Instance

251015_Unpivot – actionandi

Enjoy

Andreas