Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
poluvidyasagar
Creator II
Creator II

Incremental Load ??

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

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

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

View solution in original post

8 Replies
dilipranjith
Partner
Partner

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
Creator II
Creator II
Author

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

dilipranjith
Partner
Partner

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
Creator II
Creator II
Author

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

Error.PNG

dilipranjith
Partner
Partner

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

View solution in original post

dilipranjith
Partner
Partner

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

dilipranjith
Partner
Partner

Issue resolved?

if so please mark as answered