UPDATING A COLUMN

[razzy]

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.

[Thableaus · Accepted 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,

[razzy]

Thank you.