Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%';
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
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
Hey Peter,
Thanks, the statement: WHERE NOT to_AccountName LIKE '*Deu*' worked!
Many thanks,
Samuel