This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have 3+1 binary columns: [Apple],[Orange],[Banana] and [Don't like]. If a person likes Apple - 1, else-0 etc.. But if he doesn't like either of the 3-then Don't like will be 1.
What I want to achieve is when [Don't like] is 1, I would want to clear all values in [Apple], [Orange] and [Banana]. Please advice me your best options!
You can use a multi-field formula tool to do this. See: https://help.alteryx.com/2018.2/MultiFieldFormula.htm
Setup the tool like this:
-> Select the Fields Apple, Orange and Banana.
-> Formula enter "If [Don't Like]=1 then NULL() else [CurrentField] endif"
Hope this helps,
Possible to share sample data and result for better assistance.
Yes, see the attached sample workflow!
My posted formula wasn't entirely correct, it should be: if Dislikes=1 then null() else [_CurrentField_] endif.
Building on @Marco who helped me solve my issue.
I had a user who was incorrectly categorized as internal - I wanted to change her User Type to external, and leave all other users as-is.
Using the Multi-Field Formula tool allowed me to accomplish this. Hope this helps if you come across this.