Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Incremental Load Error

I have the following Incremental Load script running.  It runs and does increment the QVD, but I get an error that pops up and by clicking OK, it proceeds and completes.

This is the INCREMENTAL SETUP script:

incremental script.png

This is the error that I am receiving

incremental_error.png

Thanks in advance for your help!

Dan

4 Replies
Anonymous
Not applicable
Author

These are the fields being loaded

Data Load Script:

$(datatable):

Directory;

LOAD DATE,

     DIFFERENCE,

     [Reconcilation Time],

     Date_updated

FROM

[..\Data\Bank_Lockbox2.xlsx]

(ooxml, embedded labels, table is [Sheet1 (2)]);

$(INCREMENTAL_EXP)

;

Clever_Anjos
Employee
Employee

You are mixing names

Date <> DATE

Please use same name on lines "LOAD MAX" and "LET INCREMENTAL"

Anonymous
Not applicable
Author

Clever,

I dont fully understand what you mean, but I tried several combinations and still getting errors- see below.

incremental_err3.png

incremental_err4.png

Dan

Anonymous
Not applicable
Author

Clever,

I got it to work!  Thanks for the help!

incremental_err5.png