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!
