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,
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.