topic Re: During reload, exclude data present in another table in QlikView

During reload, exclude data present in another table

dukane24 — Mon, 31 Jul 2017 20:36:30 GMT

Hello,

I've created an inline table of dates that I need to exclude during reload. It's a table with a single field called, "Dates".

I've tried something like what I illustrated below, but it did not work, it ended up loading nothing at all. I thought it might work because I've used "Where Exists" to load ONLY data that matched a field in another table, so I thought trying the opposite of that would work here. I appreciate any ideas you may have.

(NOTE: I'm using more dates than this, this is just an example)

Load * Inline [Dates

2017-01-02

2017-05-29

2017-07-04

];

Load

Field1

Field2

Field3

Dates

Resident MainDataTable

Where Not Exists(Dates)

;

Re: During reload, exclude data present in another table

neelamsaroha157 — Mon, 31 Jul 2017 20:39:09 GMT

It might not be working because of difference in date format.

Re: During reload, exclude data present in another table

md_qlikview — Mon, 31 Jul 2017 20:44:51 GMT

Hi Nate,

Double check the date format of both fields from two different tables. Also if you want to load only data which will match to previously loaded table then use 'Where Exists' instead 'Where Not Exists'

Re: During reload, exclude data present in another table

tomasz_tru — Mon, 31 Jul 2017 20:48:47 GMT

MainDataTable is in memory so all the possible dates are beeing used in Exists statement.

Try:

Load * Inline [Dates_exclude

2017-01-02

2017-05-29

2017-07-04

];

Load

Field1

Field2

Field3

Dates

Resident MainDataTable

Where Not Exists(Dates_exclude, Dates)

Re: During reload, exclude data present in another table

dukane24 — Mon, 31 Jul 2017 21:01:39 GMT

Thank you sir! That worked.

Re: During reload, exclude data present in another table

tschullo — Mon, 31 Jul 2017 21:06:35 GMT

The columns don't have to have diffrent names. You could load Dates as Dates and later

LOAD

Field1

Field2

Field3

Dates

Resident MainDataTable

WHERE NOT EXISTS(Dates);