Chain IF

[Longdaica]

Hi all

I have  2 fields A & B. They all have values

So

If A > X1, then replace A with new value else do nothing 

If A get replaced from the original, B will get replace, else do nothing ....

Can you do that in Alteryx

[MarqueeCrew · Accepted solution]

Yes. Yes is always (almost) the answer.

Within one single statement the answer is not yes. Within one formula tool when helped by a select, the answer becomes YES.

Write the results of each replacement to a new variable. Then use a select to deselect the original variables with their new fields.

W-A is the new variable:

Iif(A>x1,Q,A)

Cheers,

Mark