I have a column in my data with either New, Renewal or Null as the values. We will call this Column A . I wanted to replace values in another column (we will call this column B) in my same data source file whenever there is a value of “New” in Column A. I want this replaced value in column B to be called “Zero Fill”.
Is there a tool in Alteryx that would do this? I was looking at the Find/Replace Tool as an option, but it looks like it only replaces values in the same column/field. I was also thinking a Formula might work, but not certain of the structure.
Solved! Go to Solution.
Thanks for the quick response. I should have mentioned that Column B already contains values in all the cells, so I wouldn't want to replace any of the other existing values with Null.
Perfect! That worked. Thanks for the help.
Happy to help : ) @arnettmh
Cheers and have a nice day!