How we do a Swap in Alteryx.

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);

Workflow

Datasets

Accepted answers

@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 , 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.

Can we also use case statement in alteryx

@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?