topic Excluding values in Load script in QlikView

Excluding values in Load script

siddheshmane — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

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

Thank you.

Siddhesh

tresB — Fri, 14 Jul 2017 10:29:08 GMT

Use where clause like:

Load

...

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

Or,

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

prma7799 — Fri, 14 Jul 2017 10:31:40 GMT

Like this?

Load

......

From <> Where FielName <> 'ABC' ;

Or try tresesco‌ solution above.

siddheshmane — Fri, 14 Jul 2017 10:32:05 GMT

Thanks a lot.