topic Re: not exist (better understanding) in QlikView

not exist (better understanding)

waszcma1 — Mon, 03 Sep 2018 10:39:53 GMT

I have above code working as I wonted.

Every day new set of data is loaded and concatenated into master file (NBP.qvd) I had to use temp field called Date_check to achieve this.

at the begging I have tried different code which doesn't work for the incremental load

Could you be so kind and explain me why the bottom code is not working in that case?

prieper — Mon, 03 Sep 2018 10:52:18 GMT

hmmm,

without looking at your files, it is hard to guess, what might be wrong.

Technically script is OK.

Suggest to check the formatting for currency_date, and try to use NUM(TODAY()).

Peter

swuehl — Mon, 03 Sep 2018 10:59:19 GMT

Exists() is checking against the symbol table of field currency_date, and this table is updated with every new record read from NBP.qvd.

Since currency_date is not a primary key (guess you can have the same date for multiple currencies), you will only load new data for one currency.

waszcma1 — Mon, 03 Sep 2018 11:20:33 GMT

Now I got it, Thanks a lot !!!

So if I understood correctly the following scripts use primary_key and works perfectly