Filter data

[#1]

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.

[MayilVahanan]

Hi

Try like this

Load * from tablename

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

Hope it helps

[#3]

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

[MayilVahanan · Accepted solution]

HI

Try like this

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

Hope that helps

[#5]

That works. Thanks a lot.