How we do a Swap in Alteryx.

[rohit782192]

In the above SQL i have done SWAP of Male and Female using the case statement.

Is it possible to do same in Alteryx.

update management
set MANAGEMENT_SEX =
(CASE WHEN MANAGEMENT_SEX = 'F' THEN 'M' ELSE 'F' END);

[grazitti_sapna · Accepted solution]

@rohit782192 , yes you can achieve it by using IF statement in formula tool. Here is one example.

Please accept my solution if its useful to what you need.

[rohit782192]

Can we also use case statement in alteryx

[Emmanuel_G]

@rohit782192  Yes it is possible.

You can do this using the BOM:

if test1 then result1
elseif test2 then result2
elseif test3 then
result3
.
.
.
else result_by_default endif.

You can add as many elseif as you want.

Does that answer your question?