In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

IF Formula (Basic)

MOlinski
7 - Meteor

Hello,

 

I am working on a workflow and need to update my IF statement below. We just added a "Monthly" pay group, so now it is not just Semi-Monthly and Weekly. I am trying to get it to W = Weekly, S = Semi-Monthly, and M=Monthly. But am having a hard time figuring it out, any assistance would be greatly appreciated.

MOlinski_0-1673030126354.png

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @MOlinski 

 

Try this expression:

 

[Pay Group] + '_'
+

IF Contains([Feq], "W") THEN "Weekly "
ELSEIF Contains([Feq], "M") THEN "Monthly "
ELSE "Semi-Monthly "
ENDIF

 

Felipe_Ribeir0_0-1673030552189.png

 

binuacs
21 - Polaris

@MOlinski One way of doing this

 

binuacs_0-1673031636737.png

 

Labels
Top Solution Authors