topic Data Loading into Qlikview in QlikView

Data Loading into Qlikview

Tue, 20 Oct 2009 20:07:06 GMT

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

Data Loading into Qlikview

prasad — Tue, 20 Oct 2009 21:29:16 GMT

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

Data Loading into Qlikview

Tue, 20 Oct 2009 21:51:48 GMT

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.