Incremental Load ??

[poluvidyasagar]

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

[dplr-rn]

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....

[poluvidyasagar]

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

[dplr-rn]

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....

[poluvidyasagar]

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

[dplr-rn · Accepted solution]

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);

[dplr-rn]

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

[dplr-rn]

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-fi...

[dplr-rn]

Issue resolved?

if so please mark as answered