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

Alteryx designer Discussions

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

if then else statement without overwriting

Highlighted
Alteryx Partner

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? 

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

Alteryx
Alteryx

Agree with @jdunkerley79.

 

I use this method when classifying bank statements, run through a set of matches/rules with a Find/Replace tool set to append the classification, then filter out all the ones that have been classified. I can then run through the next set of rules to match more. Like the below

 

Append_Category.png

Labels