Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
GaryMcDonald
Contributor II
Contributor II

Incremental Load in batches.

Hello,

Please could someone explain what is going wrong here and why?

This is part of an Incremental load, when I add the WHERE clause it produces the below error.

I'm trying to load the data in batches of a couple of days at a time, as I have over 11M rows and my system cant cope with a full load ( in the demo below I've done a single day to reduce the load to the minimum).

 

Thanks in advance for any help - Cheers!

GaryMcDonald_3-1627401744926.png

GaryMcDonald_5-1627401767463.png

 

 

GaryMcDonald_2-1627401485364.png

 

 

ERROR:

GaryMcDonald_0-1627401302176.png

 

Labels (2)
0 Replies