Excel formula conversion into Alteryx

[Abhii2658]

How would write this statement from excel in Alteryx 

=IF(AND(LEN(A1)>0,LEN(B1)>0),(IF(ANS=(A1&" "&B1),"Exact Match", "Non Match")),"No Trigger")

A1 = O2(String)

B1 = R1(String)

Thanks 

[Luke_C · Accepted solution]

Hi @Abhii2658 

I couldn't get the formula working in excel, but I believe this is what you're after:

if length([Field1])>0 and Length([Field2])>0 and [Field1]=[Field2]
then 'Exact Match'
elseif length([Field1])>0 and Length([Field2])>0 and [Field1] != [Field2]
then 'Non Match'
else 'No Trigger'
Endif

[Abhii2658]

Thank you very much