Find and Replace not working correctly

[rlupe]

I have the store and their sales in the top input, and find and replace numbers in the second input.

For some reason the stores are not getting replaced. 

I'm new to alteryx, this seems like it should be simple but can't get it to work.

see attached

[FrederikE]

Hey @rlupe,

What do you mean, your F&R works perfectly fine - at least for me. 

The stores in the first column are getting replaced.

I guess you want to accomplish something else - but what exactly if this isn't it? 

[FinnCharlton]

Hi @rlupe , seems to be working for me?

Before tool:

After tool:

[rlupe]

In the end result of my attached workflow there should only be stores 16451 and 18888. Store 14700 sales should convert to 18888. Sales from store 16451 should not change to 15599 since that is the store in the replace column in the bottom input.

[rlupe]

In the end result of my attached workflow there should only be stores 16451 and 18888. Store 14700 sales should convert to 18888. Sales from store 16451 should not change to 15599 since that is the store in the replace column in the bottom input.

[gaoa]

Hi @rlupe please see a revised workflow attached - added a filter to the second input to make it work.