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_3-1627401744926.png](https://community.qlik.com/t5/image/serverpage/image-id/59248i3CB1F2AFA008C0A2/image-size/medium?v=v2&px=400)
![GaryMcDonald_5-1627401767463.png GaryMcDonald_5-1627401767463.png](https://community.qlik.com/t5/image/serverpage/image-id/59250iA47A4AE6B36D12C6/image-size/medium?v=v2&px=400)
![GaryMcDonald_2-1627401485364.png GaryMcDonald_2-1627401485364.png](https://community.qlik.com/t5/image/serverpage/image-id/59247iB30027BA5A2496AE/image-size/medium?v=v2&px=400)
ERROR:
![GaryMcDonald_0-1627401302176.png GaryMcDonald_0-1627401302176.png](https://community.qlik.com/t5/image/serverpage/image-id/59245i85B12F37DAEAA4C3/image-size/medium?v=v2&px=400)