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 know there are several ways to achieve what I'm attempting, but I can't seem to get any of them to work without messing up the rest of my data. I have a field named "Company" in V_String format which contains 0 values. Whenever there is a 0 in this field, I want to change this to "UNASSIGNED" without messing with any of my other Company values.
I've tried Dynamic Replace, Switch, Conditional IF, etc. Can anyone tell me the most logical way to do this without messing up the rest of my data?
Newbie questions are the BEST! I get a fresh perspective on the use of Alteryx and get to see where potential issues are for my clients in their initial use of Alteryx. When you get multiple answers posted on a question, it is an opportunity to see how other users approach similar problems in very unique ways.
There isn't always a BEST answer and in reading posts and replies you'll get to learn lots.
Cheers to you for asking!
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Great perspective. I have one more thing to throw your way (this is the last)! I'll try to explain this as easily as possible:
I want to take the sum of an entire Field.... Then I want to take the reciprocal value of that sum and place it into the same field based on a condition within the field.
For example, say I have two fields: Company, Revenue - Company contains values 0-100 as well as an "Unassigned" field. I want to take the sum of the Revenue Field and reverse the sign, then place this result back into the Revenue Field where Company equals "Unassigned." Is this possible? Not sure how well I explained this scenario. Lol.