Folks I have a problem I can’t conceptualize in KNIME. In one table, I have a list all products that I know can be shipped together. So there are two columns with pairable items in each column.
I have a second table listing all the products for a new order. Each product in the order is a single line with the ITEMID as the lone column.
The challenge is to determine how many boxes I need for ship those items. If all rows have matching rows together in the first table, I could ship in a single box. If none match I would need 10 boxes.
Looking for some guidance on how to tackle this problem conceptually in KNIME. Say the allowed pairing table has three rows:
In my new sales order table, I see 4 lines for the products on this order:
Since A and B are matched they can ship together. And since B and D are matched, they can ship together. So by the transitive property A and D can ship together. So I can ship ITEMA, ITEMB and ITEMD in the same box. ITEMF must package separately.
Could someone toss me a few concepts of a way to tackel this in KNIME?