Partial Reload Question

Thu, 20 Jun 2013 09:57:04 GMT

Hi Folks

I have a question on using Partial Reload that you might be able to help me with.

I have a document that loads a very large (100m rows, 180 columns) QVD file, and after loading the master file (re-built daily) it then loads a series of much smaller (in terms of rows) files that are generated throughout the day. My question is, can I use a partial reload so that only the smaller files are added throughout the day?

Script currently:

TRADE_FACT:

LOAD * FROM Trade_Data.QVD;

LOAD * FROM Trade_Incremental_Data_*.QVD;

I am wondering if you think the following would work:

TRADE_FACT:

LOAD * FROM Trade_Data.QVD;

REPLACE LOAD * FROM Trade_Incremental_Data_*.QVD;

If this won't work, do you have any suggestions as to how this incremental load could be done.

Thanks,

Nigel.

Re: Partial Reload Question

Thu, 20 Jun 2013 10:26:53 GMT

Instead of "Replace" you can use "Add"..

Karthik

Re: Partial Reload Question

Thu, 20 Jun 2013 10:37:44 GMT

Pls Check...

set vLoadType = 'Delta';

If vLoadType = 'Delta' then

If NoOfRows(TRADE_FACT) > 0 then

Store TRADE_FACT into DeltaTRADE_FACT.qvd;

Else
Store TRADE_FACT into TRADE_FACT.qvd;

Regards-Bika

topic Partial Reload Question in QlikView

Partial Reload Question

Re: Partial Reload Question

Re: Partial Reload Question