Excluding values in Load script

[siddheshmane]

Hi all,

I want to exclude values that contain say 'ABC' in the string during Load Script.

Thank you.

Siddhesh

[tresB · Accepted solution]

Use where clause like:

Load

          ...

From <> Where not Wildmatch(FieldName, '*ABC*');

Or,

From <> Where not FieldName Like '*ABC*';

[prma7799]

Like this?

Load

          ......

From <> Where  FielName <>   'ABC' ;

Or try tresesco‌ solution above.

[siddheshmane]

Thanks a lot.