Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddheshmane
Creator
Creator

Excluding values in Load script

Hi all,

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

Thank you.

Siddhesh

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use where clause like:

Load

          ...

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

Or,

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

View solution in original post

3 Replies
tresesco
MVP
MVP

Use where clause like:

Load

          ...

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

Or,

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

prma7799
Master III
Master III

Like this?

Load

          ......

From <> Where  FielName <>   'ABC' ;


Or try tresesco‌ solution above.

siddheshmane
Creator
Creator
Author

Thanks a lot.