Alteryx designer Discussions

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

Performing the Same Formula on Multiple Fields

Highlighted
Asteroid

Hi,

 

I am performing the same exact If Then statement for each of the fields below. Is there one tool that allows me to update each field based on the same statement?

Formula.png

 

 

 

 

Thanks in advance!

---Kristina

Highlighted
ACE Emeritus
ACE Emeritus

Sure, Multi-Field formula is exactly what you need.

 

Hope that helps!

Asteroid

I'm not sure of your use case, but the multi field formula is designed to run the same formula against multiple fields.

 

Make sure to pay attention to the configuration.  It defaults to creating a new field, leaving the existing one intact.  If your formula is using the value in the fields (in your case Jan, Feb, etc) you would use [_CurrentField_], otherwise you could run it against another field like [Yes/No].

 

 

image.png

Highlighted
Asteroid

@BPurcell - this is exactly what I was looking for!!! Thank you.

Labels