Many to Many grouping based on BOM ?

shahafei2 — Wed, 25 Nov 2020 16:16:04 GMT

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

topic Many to Many grouping based on BOM ? in QlikView