Alteryx Designer Desktop Discussions

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

IF condition required

Srawat
8 - Asteroid

Hi,

 

Can any one advise me how I can below screen If condition prepare in Alteryx. F column result received through G column formula. Need same in Alteryx.

 

Srawat_0-1664184785761.png

 

Thanks,

 

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @Srawat,

The formula will be the exact same with the following changes:

1) instead of IF write IIF

2) remove the equals sign at the beginning

3) Columns in Alteryx are referenced in square brackets eg. [A5] not A5

 

To write a formula use the formula tool. The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

 

Your formula will start like this in Alteryx:

 

IIF([A5]...)

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

Emmanuel_G
13 - Pulsar

@Srawat 

 

Find attached the way of doing this in alteryx.

 

The key point is DateTimeDiff function between two dates. ( Documentation DateTime functions  )

 

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped. 🙂

 

Emmanuel_G_0-1664185616177.png

 

Srawat
8 - Asteroid

Thank you so much. Perfect!  "IIF" is new learning for me.

Labels