if then where

[Dima1]

Hi All.

Need to use if then where condition in alteryx but not sure how to do it.

For example if id=1 then columnB equals to columnB where id=4 

Thanks in advance.

[mborriero · Accepted solution]

You can use the formula tool.

See the attachment.