topic Re: Where Not function in App Development

Where Not function

NemoAndStitch22 — Sat, 16 Nov 2024 19:37:50 GMT

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!

Re: Where Not function

Anil_Babu_Samineni — Wed, 20 Nov 2019 13:45:43 GMT

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 ....)

Where not Match("Credit Number", '201915523', '201915522') or
Not Match("Svc Branch Number", '91', '92',..)

Re: Where Not function

NemoAndStitch22 — Wed, 20 Nov 2019 14:52:35 GMT

I've tried both ways and they are still showing in my analysis...

Re: Where Not function

Ilya_Bobrov — Thu, 21 Nov 2019 05:57:41 GMT

Mayby try this: not match(fild1,'val1','val2') and not match(fild2,'val1','val2')?

in some systems or works not like in sql query.

Re: Where Not function

tresB — Thu, 21 Nov 2019 06:15:53 GMT

You would probably need 'and', like:

Where not Match("Credit Number", '201915523', '201915522') and
Not Match("Svc Branch Number", '91', '92',..)