community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Eliminate phrase where in other list

Meteoroid

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:

clipboard_image_0.png

 

And here's the 'removals' list:

clipboard_image_1.png

 

And I need this output:

clipboard_image_2.png

 

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!

Highlighted
Nebula
Nebula

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

 

fr.png

 

R.png

Dan

Meteoroid

Aha! Told you it would be easy.

 

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

 

Thank you!

 

C

Labels