Discussion Board for collaboration on QlikView Scripting.
So i have the below section in my script, as I am trying to exclude Firms with the name ICAP in. But my wildmatch function doesn't seem to work. Is wildmatch the best way of doing this?
SQL SELECT Id,
WHERE AccountId != NULL AND WILDMATCH(Firm__c, '*ICAP*')=0;
I have also tried this, which also does not work
WHERE AccountId != NULL AND NOT WILDMATCH(Firm__c, '*ICAP*');
What am I doing wrong?
Go to Solution.
Figured it out, through trial and error
Firm__c != '*ICAP*'
thanks for your help anyway guys! It got me there in the end
Wildmatch is QV's operator, not SQL.
sql select ...;
WHERE AccountId != NULL Firm__c NOT LIKE '%ICAP%';
Wildmatch is a qlik function so you cannot use into a Select statement.
You could do
Where WILDMATCH(Firm__c, '*ICAP*')=0;
... (Your query)
otherwiseyou can use only SQL
WHERE AccountId != NULL AND not Firm__c Like '%ICAP&';
let me know
I am loading from Salesforce, so it needs an SQL statement.
The statement works absolutely fine without the wildmatch bit
Firm_c not like '%ICAP%'
WHERE AccountId != NULL AND not Firm__c Like '%ICAP%'
you missed the AND out, but it didn't work anyway
got this error
ERROR at Row:19:Column:40 unexpected token: LIKE
What is the SQL equivalent?
ERROR at Row:19:Column:39 unexpected token: LIKE