Hi ,
I have excel source file like the format below. i want to convert a group of country columns and left and right Qty into rows (Output format). kindly advise me
Source File :
Expected output :
Hey Ravishing1984,
To transform a Dataframe from long format to wideformat, you can use unpivot node the pivot it. Here is an example that might help you to take look at it.
reshape-a-table-in-knime_forum.knwf (12.5 KB)
Best,
Jinwei
3 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.