topic Re: Remove field rows on conditions in QlikView

Remove field rows on conditions

Wed, 22 Apr 2015 07:32:22 GMT

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!

Re: Remove field rows on conditions

PrashantSangle — Wed, 22 Apr 2015 07:34:20 GMT

Hi,

In script you can try

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

Regards,

Re: Remove field rows on conditions

PrashantSangle — Wed, 22 Apr 2015 07:35:25 GMT

Hi,

Your complete script like

Load * from ExcelName

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

Regards

Re: Remove field rows on conditions

jsanchezh — Wed, 22 Apr 2015 07:38:47 GMT

Hello,

You can try with

Load *,

Counterparty

From [excel file path]

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

Greetings

Re: Remove field rows on conditions

Wed, 22 Apr 2015 07:39:11 GMT

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

Re: Remove field rows on conditions

PrashantSangle — Wed, 22 Apr 2015 07:41:56 GMT

Hi,

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

Regards

Re: Remove field rows on conditions

Wed, 22 Apr 2015 07:51:25 GMT

Thank you very much! It worked!

Re: Remove field rows on conditions

Wed, 22 Apr 2015 07:58:07 GMT

Thank you for your help! It worked.