If/Then Statement Help Beginner Question

[JasmineMcCarty]

Hello,

New AlteryX user here - need to create an if/then statement with several functions but not sure what is the best tool to use?  Should the if/then statement be found under formula tool?

Thank you,

Jasmine

[TheOC]

hi @JasmineMcCarty 

The usual tool for this would be the Formula tool (Read more about it here: https://help.alteryx.com/current/designer/formula-tool)


However, there are extensions to this with the multi-row tool (https://help.alteryx.com/current/designer/multi-row-formula-tool)

And the multi-field tool (https://help.alteryx.com/current/designer/multi-field-formula-tool)

If you post an example of what you'd like to build, i can do you a workflow example 🙂 

[Emil_Kos]

Hi @JasmineMcCarty,

I found a video tutorial for you that will help you write your first IF statement in Alteryx 🙂 

https://www.youtube.com/watch?v=UZgA-KCKIQ4&ab_channel=YodaLearning-Excel%2CExcelVBAandPowerBI

Good Luck!

[atcodedog05]

Hi @JasmineMcCarty 

Here is Alteryx official iterative lesson on formula tool

https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910

Hope its helps 🙂

Feel free to reach if any specific concerns.

[Sntrada]

Hi Jasmine,  

The formula tool has If-Then logic functionality. You can start typing "i" directly into the expressions editor and the if functions would pop up. Or you can click on the fx icon to the left of the tool configuration window, and navigate to conditional functions to see which if functions are available. Once you find the one you want, click on it and it would be pasted for you to the expression editor. 

I've attached a screenshot for reference. 

Best regards!