Replace Values from One Column to Another

[arnettmh]

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.

[atcodedog05]

Hi @arnettmh 

Is this what you are looking for

Hope this helps : )

[arnettmh]

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.

[atcodedog05 · Accepted solution]

Hi @arnettmh 

Here is the updated workflow

Hope this helps : )

[arnettmh]

Perfect!  That worked.  Thanks for the help.

[atcodedog05]

Happy to help : ) @arnettmh 

Cheers and have a nice day!