We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Contains formula question

Jake5
8 - Asteroid

Hello.  As depicted in the table below, I'm trying to write a formula where if '2' is found within any of Field Value A, then ALL records in Field Value B will display 'ABC'.  Any suggestions for how to accomplish this?  Thank you. 

 

Field Value AField Value B

1

ABC
2ABC
1ABC
1ABC
3 REPLIES 3
alexm06
8 - Asteroid

Hi @Jake5 ,

 

I've attached a workflow that might solve this problem for you. Basically using the summarize tool to apply logic if there are any instances of "2" in the Field Value A column

 

Please let me know if that solves it!

Luke_C
17 - Castor
17 - Castor

Hi @Jake5 

 

Here's one way:

  1. Filter on Column A = 2
  2. Count the records from the true anchor
  3. Append the count to the dataset
  4. If the count >=1 then set field B to 'ABC'

Luke_C_0-1651684359204.png

 

 

Jake5
8 - Asteroid

Thank you both!  

Labels
Top Solution Authors