topic Not Like is returning garbage in qlikview editor in QlikView

Not Like is returning garbage in qlikview editor

Thu, 02 Jul 2009 03:17:10 GMT

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%';

Not Like is returning garbage in qlikview editor

prieper — Thu, 02 Jul 2009 03:28:53 GMT

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

Not Like is returning garbage in qlikview editor

Thu, 02 Jul 2009 03:35:25 GMT

Hey Peter,

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

Many thanks,

Samuel