How to consolidate two tables with conditional selection

I am looking for a method to combine two tables conditionally in the same manner with “Index, Match function” in Excel.
It would be great if somebody helps me to offer a solution to this problem by using Knime.

Hi @asilbozz

Take a look at the Unpivoting node .

gr. Hans

Hi,
I think you can transform table 2 into table 1 using a Pivoting node. Here, use Position as Group, Variant as Pivot and Aggregate Part_Number using the First-function. You will get the table on the left, without the Assembly Part_Number row.
Kind regards
Alexander

2 Likes

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