topic Re: Filter data in QlikView

Filter data

Wed, 31 Jul 2013 19:07:56 GMT

I have about 1000 records and 5 column fields and in some of the records the column called 'Text'; consists of a phrase 'Partner Opportunity Created' and a URL in it. This skews my data. How can I delete all rows whenever I encounter that particular phrase in the Text column.

I would really appreciate some help.

Re: Filter data

MayilVahanan — Wed, 31 Jul 2013 19:10:54 GMT

Try like this

Load * from tablename

where not wildmatch(Text,'*Partner Opportunity Created*');

Hope it helps

Re: Filter data

Wed, 31 Jul 2013 20:00:00 GMT

Thanks that works. Also what if I want to modify and have another phrase in some of the rows which I also want to filter out.

I tried the below but doesnt seems to work

LOAD text where not wildmatch(text,'*Partner Opportunity Created *') or not wildmatch(text,'*Partner incentive request rejected*');

SQL SELECT text

FROM tablename

Re: Filter data

MayilVahanan — Wed, 31 Jul 2013 20:03:39 GMT

Try like this

where not wildmatch(text,'*Partner Opportunity Created *', '*Partner incentive request rejected*');

Hope that helps

Re: Filter data

Wed, 31 Jul 2013 20:17:19 GMT

That works. Thanks a lot.