Discussion Board for collaboration on QlikView Scripting.
my objective is too have 1 and only 1 large fact table in my qvd.
Right now, I have 5 tables: 4 facts tables (sales, stock, orders, delivery) with 1 key (different from each table) and 1 product master.
My idea is to:
1) create first the 4 facts tables with product info ==> Using JOIN in load
2) Then concatenate the 4 tables into only 1 "data" table
I succeed to do 1), but how can I do 2) ?
Here is my load statement that achieve 1):
(ooxml, embedded labels, table is Sheet1)
WHERE qty <> 0;
LEFT JOIN (STOCK)
(biff, embedded labels, table is Sheet1);
WHERE [Sold Qty] <> 0;
LEFT JOIN (SALES)
[Estimated Arrival Date],
[Delivered Qty] as "In Transit Qty"
LEFT JOIN (DELIVERY)
(ooxml, embedded labels, table is Sheet1);
LEFT JOIN (LAUNCH)
Below link may help you ...
Hi, you need to reload the 4 tables you have created, something like:
load * resident STOCK;
load * resident SALES;
load * resident DELIVERY;
load * resident ORDER;
drop tables STOCK,SALES,DELIVERY,ORDER;
thanks for your detailed answer, however I now got an error during the load with following message:
Table not found
LOAD * RESIDENT SALES
and same message for other tables (stock, delivery, order)
I checked on the community and it seems I need to use the NOCONCATENATE, but my goal is to concatenate them into one table, so I'm still very confused....
If I add the NOCONCATENATE flag right after the table name (the one to consolidate all data), I don't have the error anymore.
LOAD * RESIDENT STOCK;
LOAD * RESIDENT SALES;
LOAD * RESIDENT DELIVERY;
LOAD * RESIDENT ORDER;
DROP TABLES STOCK,SALES,DELIVERY,ORDER;
However, When I look at the data source, then all my dimension fields are empty... it's like the previous JOIN statements where "forgotten". If I take back my example, DimA, DimB, DimC etc. are empty:
What I need is: