Incremental load

[Anonymous]

Hi guys, this is breaking my head, I'm creating an incremental load, but I don't know what's happening, once I concatenate the old data using not exists, the old data is reduced to 1 line per field used in not exist, any clue?

Here's the script

Incremental:

    LOAD *

    FROM

    [$(FN)](ooxml, embedded labels, table is [$(LastWk)]);

    Concatenate

    Load * FROM

    [$(QVD_Path)\JRZ_RTL_CPC.qvd]

    (qvd) where not Exists([PRD Week]);

Before incremental	After incremental

[Anonymous]

Thanks a lor Rob! This worked

I didn't know that's how not exists behaves, I really appreciate your explanation.

Regards,

Oscar Marquez

[harsh44_bhatia]

Something more on the exists function on the same lines:

If you want to do the distinct load on a field we can use:

Load A, B, C, from Employees.csv where not exists (A);

This is equivalent to performing a distinct load on field A.

Read about this in the help file for exists function it will help you in clearing your concepts about exists  function, also do understand on how Qlik stores data internally in form of bit stuffed pointers.