topic IL load issue in QlikView https://community.qlik.com/t5/QlikView/IL-load-issue/m-p/491649#M1124790 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i think somethink wrong with my script.. when i load full load, i get&nbsp; 332923 lines, but when i load incremental load i get&nbsp; 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.</P><P></P><P>Please help</P></BODY></HTML> Fri, 10 Jan 2014 08:20:07 GMT 2014-01-10T08:20:07Z IL load issue https://community.qlik.com/t5/QlikView/IL-load-issue/m-p/491649#M1124790 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i think somethink wrong with my script.. when i load full load, i get&nbsp; 332923 lines, but when i load incremental load i get&nbsp; 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.</P><P></P><P>Please help</P></BODY></HTML> Fri, 10 Jan 2014 08:20:07 GMT https://community.qlik.com/t5/QlikView/IL-load-issue/m-p/491649#M1124790 2014-01-10T08:20:07Z Re: IL load issue https://community.qlik.com/t5/QlikView/IL-load-issue/m-p/491650#M1124791 <HTML><HEAD></HEAD><BODY><P>The problem is the exists statement.</P><P>QlikView will only load 1 dataset from the qvd for each offeringid. Then it exists and the second dataset is not loaded.</P><P>Maybe you can create an explicit field for example union offingid&amp;timestamp of last change</P><P>Regards</P></BODY></HTML> Fri, 10 Jan 2014 09:01:09 GMT https://community.qlik.com/t5/QlikView/IL-load-issue/m-p/491650#M1124791 martinpohl 2014-01-10T09:01:09Z