Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Incremental Load is Not Working

Hello,

I am using Qlik Sense and have the following script. But when I run the script, only the data from Incr_Invoices table (e.g. 10 records) are kept. None of the data from Invoices table (e.g. 1000 records) are brought into Incr_Invoices table (i.e. After the concatenation, Incr_Invoices table has 10 records). There are different InvoiceRecordID's in both tables.

I saw that there were some issues with "where not exists" command with QVD file created by Qlik Sense:  http://community.qlik.com/thread/129921

Is this true? If so, is there an update to this issue?

Your advise is greatly appreciated!

Incr_Invoices:

    LOAD *

FROM [lib://Spend/SPEND_DATA*.xlsx]

(ooxml, embedded labels, table is [08]);

Invoices:

NoConcatenate

        Load *

from [lib://Spend/InvoicesBasic.qvd] (qvd) where 1=1;


Concatenate (Incr_Invoices)

        Load *

Resident Invoices

where Not Exists(InvoiceRecordID);

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This issue is now fixed in Qlik Sense 2.0.2

View solution in original post

4 Replies
maxgro
MVP
MVP

Incr_Invoices:

    LOAD *

FROM [lib://Spend/SPEND_DATA*.xlsx]

(ooxml, embedded labels, table is [08]);

Concatenate (Incr_Invoices)

        Load *

from [lib://Spend/InvoicesBasic.qvd] (qvd)

where Not Exists(InvoiceRecordID);

Anonymous
Not applicable
Author

Massimo, thank you for your feedback. I tried the script, and all 10 records from InvoicesBasic.qvd got added to Incr_Invoices table.

This sounds like the behavior mentioned in the linked discussion topic mentioned above: http://community.qlik.com/thread/129921

"It seems as if in QlikSense the Where Exists is ignored and the whole QVD is loaded."

Do you or anyone else have additional suggestions?

Anonymous
Not applicable
Author

Hello all,

Is there a different method other than 'where not exists' to do incremental load?

Anonymous
Not applicable
Author

This issue is now fixed in Qlik Sense 2.0.2