Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

if then else statement without overwriting

bb213
8 - Asteroid

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? 

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

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

KaneG
Alteryx Alumni (Retired)

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