Hi all i updated my alteryx version and i happen to loose all my formulas i have been working with. I have to columns
1. DOMINANT
2. NON_DOMINANT
I am trying to input one from the other , i am using a formula tool with the selected column NON_DOMINANT
and the formula
IF [DOMINANT]=="Right"
THEN [NON_DOMINANT]=="Left"
ELSEIF [DOMINANT]=="Left"
THEN [NON_DOMINANT]=="Right"
ELSE [NON_DOMINANT]
ENDIF
But then the columns keeps outputting Boolean 0 or -1. even though the data type is V_string, can anyone help me with what i may be doing wrong.
Attached is the worksheet and the columns after the operation.
Solved! Go to Solution.
Hi @razzy
you should change to this:
IF [DOMINANT]=="Right"
THEN "Left"
ELSEIF [DOMINANT]=="Left"
THEN "Right"
ELSE [NON_DOMINANT]
ENDIF
It should work.
Cheers,
Thank you.