We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula

dholder15
7 - Meteor
‎07-10-2023 07:59 AM

I'm trying to figure out how I can create a column that takes the value in VH based on emp status = "Terminated". I think I'm over thinking something so simple. Let me know if there is any solution out there. 

Preview file
9 KB
Reply
0 Likes
1 REPLY 1
SPetrie
13 - Pulsar
‎07-10-2023 08:30 AM

If [empstatus]="Terminated" then [VH] else null() endif

If you are creating a new columns, using this as the formula should do it.

Reply
0 Likes
Labels
Top Solution Authors
View All