Eliminate phrase where in other list

[CDunhill]

Hello,

Bit of an Alteryx noob so hopefully this is an easy one (in fact so easy I couldn't find anyone on here asking the same question?).

How do I clear values in an address list when found in another list? See attached file.

eg. here's the address list:

And here's the 'removals' list:

And I need this output:

Now, I know I can do this using IF statement etc but I figured there must be a cleaner way? Makes sense to keep a separate list of phrases to remove.

Thanks in advance!

[danilang · Accepted solution]

Hi @CDunhill 

The Find Replace tool is your friend here.  Just add a ReplaceWith field with empty strings "" in your Remove list and configure it to match the entire field

Dan

[CDunhill]

Aha! Told you it would be easy.

I did try Find/Replace yesterday but couldn't configure it to do this.

Thank you!

C