Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hello,
You can try with
Load *,
Counterparty
From [excel file path]
Where not wildmatch(Counterparty, 'INT*', 'EXT*');
Greetings
Hi,
In script you can try
Where not wildmatch(fileName,'INT*','EXT*');
Regards,
Hi,
Your complete script like
Load * from ExcelName
where Where not wildmatch(fileName,'INT*','EXT*');
Regards
Hello,
You can try with
Load *,
Counterparty
From [excel file path]
Where not wildmatch(Counterparty, 'INT*', 'EXT*');
Greetings
Thank you for the reply. What should I replace fileName with?
Hi,
It should be your fieldNAme in which you are searching for particular string.
Regards
Thank you very much! It worked!
Thank you for your help! It worked.