Urgent! How to turn the data format by using unpivoting or other functions?

[HKuser]

Hi Everyone, I would like to know that Can I use unpivoting to perform this result?

Here is the original data format.
I want to combine all order code, amount and cost to three columns respectively.

Here is the expected result.

Please HELP!!! Many Thanks!!!

Knime.xlsx (9.5 KB)

[tommy]

hi @HKuser,

I uploaded a workflow to my public hub…

Z_022_unpivot – tommy

In my solution I go for a unpivot -> pivot combination.
In the table creator you have to define how much combinations of amount-order-cost exist. In your example there are 3.

Hope that helps, regards, Tommy

[HKuser]

how can i download your workflow?

[HansS]

Hi @HKuser

A little bit different approach, but also using the Unpivot node. unpivot_and_rank.knwf (31.4 KB)

gr Hans

[tommy]

drag & drop the yellow icon on the upper right of the KNIME hub page to your KNIME workspace.
@HansS solution is great. It gets rid of the loop.

[ipazin]

Hello @HKuser,

here is my solution using 3 times Create Collection Column node follwed by Ungroup node.
unpivot_and_rank_ipazin.knwf (27.1 KB)

Br,
Ivan

[Daniel_Weikert]

Wouldn’t have thought about that way. Very nice ipazin. Thanks for sharing! BR