Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Remove field rows on conditions

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!

1 Solution

Accepted Solutions
jsanchezh
Contributor

Re: Remove field rows on conditions

Hello,

You can try with

Load *,

     Counterparty

From [excel file path]

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

Greetings

7 Replies

Re: Remove field rows on conditions

Hi,

In script you can try

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Remove field rows on conditions

Hi,

Your complete script like

Load * from ExcelName

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
jsanchezh
Contributor

Re: Remove field rows on conditions

Hello,

You can try with

Load *,

     Counterparty

From [excel file path]

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

Greetings

Not applicable

Re: Remove field rows on conditions

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

Re: Remove field rows on conditions

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Remove field rows on conditions

Thank you very much! It worked!

Not applicable

Re: Remove field rows on conditions

Thank you for your help! It worked.

Community Browser