Discussion Board for collaboration on QlikView Layout & Visualizations.
i have three fact table. i want to concatenate them and create a qvd file with incremental load.. please help me how to do it..
Please have a look the tables shown below.. All the dimensions are common to all three fact tables..
Please share your experience...
Hi - try this:
'Source1' AS FACT_Type,
'Source2' AS FACT_Type,
'Source3' AS FACT_Type,
STORE FACT INTO FACT.qvd;
Then, on your incremental load (S_ORIG_CODE is a unique identifier):
LOAD * FROM FACT.qvd;
WHERE NOT EXISTS(S_ORIG_CODE);
Hope this helps,