Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Creator
Partner - Creator

Hello,

You can try with

Load *,

     Counterparty

From [excel file path]

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

Greetings

View solution in original post

7 Replies
PrashantSangle

Hi,

In script you can try

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
jsanchezh
Partner - Creator
Partner - Creator

Hello,

You can try with

Load *,

     Counterparty

From [excel file path]

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

Greetings

Not applicable
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Thank you very much! It worked!

Not applicable
Author

Thank you for your help! It worked.