Where Statement in load scripts

[tsoley9262]

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.

[Claudiu_Anghelescu]

WHERE Not Match (Disposition, 'AD Decommission')

[tsoley9262]

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

[marcus_sommer]

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