Item / Bill of Material

[macpao64]

Hello every one,

I’m a beginners with QlikView so I’m traying to understand how design my "data model" in the best way.

I have a some problems with a table bill of material.

Scenario: (see the file)

I’ve a ITEM table which shows the main data of the items, a BOM table which shows the parent item, the first level child item ad some data.

Which is the best way to "link" the child item on BOM with the item on ITEM?

As now, I can search a parent item code in the BOM table and go to the ITEM table using the key "item".

I'd like to do the same  but searching a child item code in the BOM table

I think I should modify the model, for example duplicate the table ITEM, one for parent one for child… or create a new key...

but I do not know exactly how!!! 

Thanks

Paolo Macchi

[#2]

Hi,

Maybe create the field ITEM_CHILD as key in the table ITEM.

[macpao64]

Hi Amanda,

thanks a lot for your answer,

in this way  QlikView will create:

         a $Syn Table (item, item_child)

         a synthetic key into ITEM table and into BOM table

I should create a “flat hierarchical structure” into the ITEM table,

for each item there’ll be many rows, one for each first level child

bye

Paolo