We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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
10 - Fireball

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

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
13 - Pulsar

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 

 

flying008
13 - Pulsar

Hi,@csh8428 

 

You can use the formula to filter:

 

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

 

flying008_0-1678408550410.png

 

Labels