Replace Values from One Column to Another

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 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.

Preparation

Accepted answers

atcodedog05

Hi @arnettmh

Here is the updated workflow

Hope this helps : )

zero fill.yxmd

All comments

atcodedog05

Hi @arnettmh

Is this what you are looking for

Hope this helps : )

zero fill.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703