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