Data Loading into Qlikview

[#1]

Hi

Find attached current table format in our ERP system, and required qlikview format for some of our reports, please suggest a best way to design

Regards

[prasad]

hi,

i think you can create a master table to link product code and level seperately and link the table. Remove the Level column in the excel sheet. Maybe this helps. "Thanks!

Prasad

[#3]

without knowing your info or business, based on your example, I would go for something like this:

Products:
LOAD ID as Product_Id, PRODUCT_CODE
FROM [BOM_2D00_REPORT.xlsx] (ooxml, embedded labels, table is Sheet1);
Components:
LOAD ID as Product_Id, autonumber(COMPONENT_CODE) as Component_Id, COMPONENT_CODE
FROM [BOM_2D00_REPORT.xlsx] (ooxml, embedded labels, table is Sheet1);
Usage:
LOAD autonumber(COMPONENT_CODE) as Component_Id, USAGE_QUANTITY, [MAKE OR BUY]
FROM [BOM_2D00_REPORT.xlsx] (ooxml, embedded labels, table is Sheet1);

P.s. There's no criteria in the first format to autogenerate the level column.