Help with IF THEN

[J25607]

New to Designer.  My field name is [AG/UG] and contains these numeric values (3000, 3100, 7000, and 7100).  Trying to write an IF THEN statement that would change the 3100 and 7100 to equal "AG" (just the letters) text string, and, to change the 3000 and 7000 to equal "UG".  Your help is greatly appreciated!

[Luke_C]

Hi @J25607 

Assuming your field is numeric you could do the below. If it's text then put quotes around the numbers.

IF [AG/UG] IN (3100,7100) then 'AG'
ElseIf [AG/UG] IN (3000,7000) then 'UG'
Else Null()
Endif

[ChrisTX · Accepted solution]

You'll need to create a new field, because the data type will be text

IF [my field] IN (3100, 7100) THEN "AG"

ELSEIF [my field] IN (3000, 7000) THEN "UG"

ELSE "<unknown>"

ENDIF

Chris

[J25607]

Luke, tried your suggestion.  Still get an error.

Chris, how/where would that new field be created?

Thanks!

[Luke_C]

Hi @J25607 

You'll need to be more specific and include the error to get any meaningful help. My solution is the same as what @ChrisTX 's is. You'd do it by adding a new field in the formula tool - see attached.

[J25607]

Thank you both!!

[Luke_C]

You're very welcome! Be sure to mark the solution(s)

[ChrisTX]

Create a new field: Use the Formula tool

Suggestion for just starting to use Alteryx:  at the top of this page, try Learn > Academy

  Learning Paths

  Interactive Lessons

  Videos

[J25607]

Luke, sorry but this is still returning the numeric values no the AG & UG.  I copied your formula as is. 

[Luke_C]

@J25607 Provide a screenshot please, or your workflow.