Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya,
I'm trying to load my data in and have used in the script a 'where not' to exclude two credit numbers - See the photo, however this is not working and when I go to create my visualisations, the two credit numbers are included in the data.
What am I doing wrong here? The same is happening with the Svc branch number.
Thanks!
Mayby try this: not match(fild1,'val1','val2') and not match(fild2,'val1','val2')?
in some systems or works not like in sql query.
You would probably need 'and', like:
Where not Match("Credit Number", '201915523', '201915522') and
Not Match("Svc Branch Number", '91', '92',..)
Perhaps these ways
Where not ("Credit Number" like '201915523' or "Credit Number" like '201915522') or
Not ("Svc Branch Number" like '91' or "Svc Branch Number" like '92' or ....)
Or
Where not Match("Credit Number", '201915523', '201915522') or
Not Match("Svc Branch Number", '91', '92',..)
I've tried both ways and they are still showing in my analysis...
Mayby try this: not match(fild1,'val1','val2') and not match(fild2,'val1','val2')?
in some systems or works not like in sql query.
You would probably need 'and', like:
Where not Match("Credit Number", '201915523', '201915522') and
Not Match("Svc Branch Number", '91', '92',..)