if then else statement without overwriting

Question

I have an if statment in a formula tool with about 100 different cases that is trying to assign a value based on a condition. Once I assign a value, I don't want it to be overwritten down the line, i.e., i want Alteryx to "bucket" it and exclude it, thereby not overwriting the values, which is what is happening now.  What is the best way to accomplish this?

jdunkerley79 · Accepted Answer

Hard to advise without seeing your expression but two suggestions jump to mind:

1. Use a switch statement (https://help.alteryx.com/11.5/Reference/Functions.htm#Conditional)

2. Use a Find and Replace tool (https://help.alteryx.com/11.5/index.htm#FindReplace.htm)

If you can post more details happy to help