topic Re: Incremental loading with two fact tables?? in QlikView

Incremental loading with two fact tables??

sushil353 — Fri, 02 Sep 2011 04:29:33 GMT

Hi All,

In my dashboard i have two fact tables... say FACT1 and FACT2.. also there are other dimentions too...

In both fact table there is time_id by which we can restrict the data...

My problem is... first i want to load previous 30 days of data to start with and then data from both fact table should be incremented every 4 hour in 30 days data.

how to make qvd file and store them such that when they are incremented/refreshed successfully i can use them in my dashboard/application.

Pleas help me out to solve this problem..

Thanks...

Re: Incremental loading with two fact tables??

Fri, 02 Sep 2011 06:28:30 GMT

Hi,

Does it mean you always just need last 30 days data in your dashboard and then in QVD?

Chers.

Re: Incremental loading with two fact tables??

Fri, 02 Sep 2011 06:37:32 GMT

Hi,

I think with some modifications to original fileds that you have and taking care in the date format you can try the below script.

//First create a snapshot of 30 days data and store in QVD, this step is one time only.
//Last30daysTranData:
//Load time_id, ctry,prod from table table1 where time_id>=Today()-30;
//
//Store Last30daysTranData into Last30daysTranData.QVD;
//Please uncomment the above code and comment everyhting else to create a snapshot
//Once you created the above snapshot, load data from QVD
//any data beyond 30 days will not be loaded
Last30daysTranData:
Load * from Last30daysTranData.QVD where time_id>=Today()-30;
//this will append incremental data which is not there in above QVD
Concatenate (Last30daysTranData)
Load time_id, ctry,prod from table databasetable where time_id>=Today()-30;
Store Last30daysTranData into Last30daysTranData.QVD;

Cheers.