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
8 - Asteroid

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
17 - Castor
17 - Castor

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