Hi everyone
Quite new to Alteryx Designer and need some help with a conditional statement - think I need to do a nested IF but need some help writing the formula in the formula tool
I want to do the following:
| My gender identity is different than my sex at birth | New column and desired output |
| No | Same as birth gender |
| Yes | Different than birth gender |
| Prefer not to answer | Prefer not to answer |
| | |
Last row is blank. If blank, need the new column to be blank too.
Thanks,
KA