If and contains formula error

[lilyyangadsk]

hello sir, may i ask you how to write multi condition "If" / "and"/ "or" formula for attached data. 

[binuacs]

@lilyyangadsk Not sure I understand your requirement properly, I think you need to your Test value equal to the (LC Alteryx Mark) value

[lilyyangadsk]

Is your formula same as mine? i can't see diff.

[grazitti_sapna]

Hello @lilyyangadsk, your formula seems to be correct but the issue is with the Match score column whose data type was set to V-string after changing the data type to Double it is working fine.

Attaching the workflow along.

Thanks!

[lilyyangadsk]

if i change to double data type, and i use my formula and second record ID still shows error. but i cant see the diff between yours and my formula :(

[grazitti_sapna]

Hi @lilyyangadsk, in my version of the formula tool I did not change anything I just added a select tool and changed the data type.

In your new workflow shared there is a difference in elseif condition

Try changing to UUID Check='F' into UUID Check into ('T','F'). It will work for you as well.

Thanks! 

[binuacs · Accepted solution]

@lilyyangadsk Yes, I added the below condition in the formula to match the result

[lilyyangadsk]

may i know [UUID Check]  IN('T', 'F') meaning "F"?

[grazitti_sapna · Accepted solution]

@lilyyangadsk, As per my understanding F might be referenced to False and T referenced to True. It is mentioned in your dataset as T or F.

Thanks!

[lilyyangadsk]

Thank you!