This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
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
What I need to show
@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
I'd follow this approach.
What kind of formula is this? I thought once you write EndIf it ends the formula
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