Solved: not exist (better understanding) - Qlik Community

waszcma1 · ‎2018-09-03

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?

swuehl · ‎2018-09-03

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.

prieper · ‎2018-09-03

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 · ‎2018-09-03

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 · ‎2018-09-03

Now I got it, Thanks a lot !!!

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