Free Trial

Alteryx Designer Desktop Discussions

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

Workflow for a Nested IF and Xlookup

padfooot
5 - Atom

Hi there! I started using Alteryx recently so I’m still trying to figure things out. I have a nested IF and Xlookup formula in excel that I’d like to recreate. I use the Formula function to replicate IF statements and Find Replace for Xlookups, but I’m not sure what to do for nested formulas. Could someone please help me build a workflow for this?


I have 2 input data and here is the formula as well: 

IF(Condition 1, Xlookup, IF(Condition 2, Result A, Result B))

 

Thanks in advance!

1 REPLY 1
geraldo
13 - Pulsar

@padfooot 

 

iif(Condição 1, Xlookup, iif(Condição 2, Resultado A, Resultado B))

Labels
Top Solution Authors