Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

StartsWith funciton not working as expected

craigja
11 - Bolide

Im trying to exclude some dummy active directory accounts that have been setup in the past.... They all start with bl and I thought I could use the filter tool with StartsWith('bl', [identity]) but this doesnt exclude them, if I put in the full name of one of the accounts it picks it up though, its like I need 'bl*' as a wildcard or something

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

If you want the filter to EXCLUDE those that start with bl, the filter logic should be !StartsWith([identity],”bl”)and seeing the T anchor! Or StartsWith([identity],”bl”) and looking at the F anchor

Labels
Top Solution Authors