5 Replies Latest reply: Nov 14, 2014 4:16 PM by Swarup Malli RSS

    Where not match?

    Matt Maino

      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.