Alteryx Designer

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

Formula to update field for specific scenario

Highlighted
5 - Atom

Hi - I have a set of data where the I have a listing of Team names and a Country that corresponds. I have 2 teams that incorrectly listed their Country names in a system and every month I have to manually update the Country that corresponds with that team. I am trying to do a formula to make this update but not sure if that is the best choice as I am not getting the expected output. Can someone please help?

 

Example:

 

 

Alteryx.PNG

Highlighted
9 - Comet

You should be able to use the formula tool to update the Country field. This is a static fix but works IF [Team Name]="Team 1" OR [Team Name]="Team 3" THEN "United States" ELSE [Country] ENDIF

Highlighted
5 - Atom

That worked, thank you! I was just missing the ENDIF :) 

Labels