topic Re: Incremental Load ?? in QlikView

Incremental Load ??

poluvidyasagar — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying incremental data load with a sample data.

It gives me error when i load the data.

Can someone check if the sequence of steps are correct and what is the error in the script?

Thanks,
VIdya

vishsaggi‌

Can you look at this?

Message was edited by: Vidya Sagar Polu

Re: Incremental Load ??

dplr-rn — Mon, 24 Sep 2018 18:39:10 GMT

as i dont have the qvd not able to run it. Whats the error? From a quick look i would assume its table not found when you are concatenating (line 30).

when you load table 'Incremental' it will automatically concatenate with the table 'Data' as the column names are the same. you need to put

Incremental:

NoConcatenate

Load....

Re: Incremental Load ??

poluvidyasagar — Mon, 24 Sep 2018 18:52:50 GMT

I have added the QVD file.. Can you please check now?

Re: Incremental Load ??

dplr-rn — Mon, 24 Sep 2018 18:59:59 GMT

saw the new qvd

yes it was i expected .

When 2 tables with same column names is loaded qlik automatically concatenates it unless you specially tell it not to

use

Incremental:

NoConcatenate

Load....

Re: Incremental Load ??

poluvidyasagar — Mon, 24 Sep 2018 19:14:52 GMT

I keep getting the following error whenever i add more data to the data file.

Re: Incremental Load ??

dplr-rn — Mon, 24 Sep 2018 19:30:49 GMT

looks like your max date variable is empty. qvd may have become empty

wanted to add regarding your logic. not sure why you are loading data.qvd again and saving table incremental. i would load incremental, concate the value from incremental into already loaded table Data, store table Data into qvd

// Load Incremental Data

Incremental:

NoConcatenate

LOAD Date,

OrderNum,

Qty

FROM

Data.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Date > $(Last_Updated_Date);

// Concatenate the data from incremental with QVD file

Concatenate (Data)

LOAD Date,

OrderNum,

Qty

resident Incremental;

// Replace Old QVD File

STORE Data into Data.qvd(qvd);

Re: Incremental Load ??

dplr-rn — Mon, 24 Sep 2018 19:37:30 GMT

attaching files. add another row with newer date to excel and it will load it into qvd

Re: Incremental Load ??

dplr-rn — Mon, 24 Sep 2018 19:42:10 GMT

check below posts for better theoretical understanding

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/‌

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-files-incremental-load…

Re: Incremental Load ??

dplr-rn — Tue, 25 Sep 2018 17:00:08 GMT

Issue resolved?

if so please mark as answered