Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
9 - Comet

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