Hi everyone,
How could I match between many to many?
I have two different tables (Inventory and BOM) as shown below
I would like to convert the data as part of the load script in a way that I will have an inventory based on the BOM_ID
(For the example below I wish to have 2 items in location X instead of 5 -based on BOM_ID 1111(1 Unit) and 2222(2 Units))
Does it possible somehow?
Inventory:
Location_ID, Item_ID, QTY
X,A,6
X,AA,6
X,AB,6
X,B,21
X,CA,14
BOM:
BOM_ID, Item_ID(Child part), Qty
1111,A,6
1111,AA,6
1111,AB,6
1111,B,5
2222,CA,7
2222,B,8
