hello sir, may i ask you how to write multi condition "If" / "and"/ "or" formula for attached data.
@lilyyangadsk Yes, I added the below condition in the formula to match the result
@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 Not sure I understand your requirement properly, I think you need to your Test value equal to the (LC Alteryx Mark) value
Is your formula same as mine? i can't see diff.
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.
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
may i know [UUID Check] IN('T', 'F') meaning "F"?
Thank you!
Thank you, it works.