community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Formula

What formula can I use that populates the state column with the same number as either the county, city or district column?

 

What currently shows

Statecountycitydistrict
556465556465556465556465
 328328328
  2221522215

 

What I need to show

Statecountycitydistrict
556465556465556465556465
328328328328
22215 2221522215
Asteroid

@garretwalters12 how about something like this? It gives the desired output for the views you shared. Not sure if city/district are always the same values in your full data.

 

Add a formula tool and specify State as the output column:

IF state=' ' THEN [city] ELSE [State] ENDIF

 

 

Alteryx Certified Partner

Hi @garretwalters12 

 

I'd follow this approach.

 

1.PNG2.PNG

What kind of formula is this? I thought once you write EndIf it ends the formula

Alteryx Partner

each IF needs a matching ENDIF, so when you nest them together it has the cascading effect of checking each of the fields .... just in case the field you first checked is also null

Labels