Not Like is returning garbage in qlikview editor

[#1]

Good Afternoon, I am writing a script in the qlikview editor and I am trying to execute the code below. Basically What I am trying to do is to filter out any patterns that starts with Deu. I tried using NOT LIKE but I recieve an error saying that the statement is garbage after the where. Any ideas will be grateful!

External:
Load to_UUID,
 to_AccountName as externals
Resident Recipients
where to_AccountName NOT LIKE '%Deu%';

[prieper · Accepted solution]

Hi,

the wildcard in QV is usually *, not the %.

am not sure on the usage of the LIKE, have you tried

WHERE NOT to_AccountName LIKE '*Deu*'

Alternatively

WHERE NOT WILDMATCH(to_AccountName, '*Deu*')

HTH

Peter

[#3]

Hey Peter,

Thanks, the statement: WHERE NOT to_AccountName LIKE '*Deu*' worked!

Many thanks,

Samuel