topic Where Statement in load scripts in QlikView

Where Statement in load scripts

tsoley9262 — Wed, 25 Nov 2020 16:16:04 GMT

I am using this where statement in my load scripts to exclude any AD Decommission from my data but when I use this statement "where Disposition <> 'AD Decommission';" it is also excluding any blank fields to which I don't want to happen.

Re: Where Statement in load scripts

Claudiu_Anghelescu — Fri, 01 Mar 2019 22:58:04 GMT

WHERE Not Match (Disposition, 'AD Decommission')

Re: Where Statement in load scripts

tsoley9262 — Mon, 04 Mar 2019 12:17:35 GMT

I am getting a error saying Match is not a recognized built in function name

Re: Where Statement in load scripts

marcus_sommer — Mon, 04 Mar 2019 14:41:31 GMT

In general your statement should work. Maybe it's a special feature from your database-driver. If your load isn't too heavy you could transfer the where-clause to a preceeding load and there you could also use the qlik-functions like the suggested match(). This means the following:

load * where not match (Disposition, 'AD Decommission');
sql select * from table;

- Marcus