topic Re: loading script - how to exclude data that start with "A..." in QlikView

loading script - how to exclude data that start with "A..."

jim_chan — Fri, 29 Sep 2017 02:14:22 GMT

hi guys,

just a simple question. i have a field, which have data such as A10001, 120111. i need to get rid/exclude of those A* data for that particular field when i am doing the loading script. how should i write...?

Load

Where Not MixMatch(ID, 'A*');

will this work?????

rgds

jim

Re: loading script - how to exclude data that start with "A..."

vishsaggi — Fri, 29 Sep 2017 02:31:19 GMT

May be try this:

Load

Where Not WildMatch(ID, 'A*');

Load

Where Num(ID);

Re: loading script - how to exclude data that start with "A..."

jim_chan — Fri, 29 Sep 2017 02:35:24 GMT

Hi Vish,

i ahve used this Where Not WildMatch(ID, 'A*');

and it work.

thank you.