Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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