Excluding certain records on Data Load

[msawyercke]

Hello,

I'm loading records in Data Load Mgr, but would like to exclude a small number (6 records) based upon their unique 'PS #" assignment.  After searching this forum, I think I need to use the "where not" command in my script.

Here is the script I created using this command.

This yields an "Unknown Statement' error.  I'm sure it is just a syntax, or command placement error,

Can anyone help, please?

Much appreciated!

[sunny_talwar · Accepted solution]

Try this:

Where not Match("PS #", 1506919, 1100919, 1505558, 1505559, 1505566, 1505567);

[msawyercke]

Sunny - you are absolutely THE B E S T !

Thanks again and I hope you have a nice day. 

[sunny_talwar]

Hahahaha thanks Mike, I am glad I was able to help my friend