Remove field rows on conditions

[#1]

Hi,

I have a simple question. I have an Excel file which I loaded into Qlikview. I want to remove entire rows if a field contains certain characters. More specifically, I have a field named Counterparty. I want to remove the entire row if the field Counterparty contains a name that begins with INT or EXT.

Thanks!

[PrashantSangle]

Hi,

In script you can try

Where not wildmatch(fileName,'INT*','EXT*');

Regards,

[PrashantSangle]

Hi,

Your complete script like

Load * from ExcelName

where Where not wildmatch(fileName,'INT*','EXT*');

Regards

[jsanchezh · Accepted solution]

Hello,

You can try with

Load *,

     Counterparty

From [excel file path]

Where not wildmatch(Counterparty, 'INT*', 'EXT*');

Greetings

[#5]

Thank you for the reply. What should I replace fileName with?

[PrashantSangle]

Hi,

It should be your fieldNAme in which you are searching for particular string.

Regards

[#7]

Thank you very much! It worked!

[#8]

Thank you for your help! It worked.