IF condition required

[Srawat]

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.

Thanks,

[IraWatt]

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 · Accepted solution]

@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. 🙂

[Srawat]

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