Where not match?

[#1]

I am importing an excel file that contains a few fields - one of them being zip_code. I would like to only import those rows from the excel file that do not contain a specific set of zip codes and for some reason nothing that I try works.

this is what I have as the where clause:

where not match(ZIP_CODE, 55555,44444,33333,22222);

does anybody know why this is not working? The script re-loads, but the zip codes are still there.

Thanks

[#2]

Have you tried:   where match(ZIP_CODE, ........) = 0

[#3]

That doen't work either. The only thing that I have been able to get working is:

where ZIP_CODE <> 55555;

but that only works for one

[swarup_malli]

try

where not match(ZIP_CODE, '55555','44444','33333','22222')

[#5 · Accepted solution]

Any chance the imported data is TEXT you need to wrap your zip codes with quotes '55555', '666666' etc?

[swarup_malli]

You are missing quotes

Or you can create a Flag_ZIPCODE  COLUMN in the excel

then

specify

where Flag_ZIPCODE <> '1'

here 1 corresponds to values you want to filter