IL load issue

[#1]

Hi All,

i think somethink wrong with my script.. when i load full load, i get  332923 lines, but when i load incremental load i get  only 6398 lines..i want load from sql only new or modified records, and concatenate wiht old qvd files by not exist id. and store in qvd.

Please help

[martinpohl]

The problem is the exists statement.

QlikView will only load 1 dataset from the qvd for each offeringid. Then it exists and the second dataset is not loaded.

Maybe you can create an explicit field for example union offingid&timestamp of last change

Regards