Alteryx Designer Discussions

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

Bring in remaining data from If Then statement

8 - Asteroid

I'm trying to consolidate the names of some of our departments.  What formula can I use to perform an IF-THEN statement on some of our departments, but still bring in the remaining departments that I don't want to rename?

 

That may have been confusing.  Let me try to explain this way:

If I have a list of A, B, C, D and I want to rename C and D to call them E how can I create a column that still shows all the A's and B's and the newly renamed E's?  Below is my working formula to rename the departments I needed, but it is not displaying the other department names that I don't want to rename.

I hope that makes sense. 🙂

 

skeen503979_0-1581699064522.png

 

17 - Castor
17 - Castor

Hi @skeen503979 

 

Instead of the Null() in your Else clause use [DEPT_DESC]. 

 

Dan

Alteryx
Alteryx

hi @skeen503979 ,

 

hope this helps!

 

bpatel_0-1581699926882.png

 

8 - Asteroid

@danilang 

 

That worked for me.  Thanks so much for the help!

Labels