Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
---|---|
Thanks a lor Rob! This worked
I didn't know that's how not exists behaves, I really appreciate your explanation.
Regards,
Oscar Marquez
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.