In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to flag a record if a concatenated string contains something OTHER THAN a given value?

csh8428
11 - Bolide

I'm trying to figure how to flag a record if a concatenated string contains something OTHER THAN a given value. I don't know all the values a cell may have, otherwise I would just use a contains and search for those values to flag it.

 

For example:

I want to flag a cell if it contains ANY value OTHER THAN just "A".

Field value: A,B,A,C,D,G,H. <-- this would be flagged

Field value: A,A,Z <-- this would be flagged

 

Field value: A,A,A,A,A <--this would NOT be flagged

 

Thanks,

Craig

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @csh8428 

 

You could split the data to rows then count the distinct values to do this.

 

Luke_C_0-1678396224113.png

 

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

I'd use RegEx match:

BS_THE_ANALYST_0-1678396280777.png

This regex basically says, the string will match true if it only contains commas or the letter A (or lowercase a) @csh8428 

 

All the best,
BS

LinkedIN

Bulien
flying008
15 - Aurora

Hi,@csh8428 

 

You can use the formula to filter:

 

Length(Trim(ReplaceChar([Txt], "A,", ''))) > 0

 

flying008_0-1678408550410.png

 

Labels
Top Solution Authors