Filtering a table to remove rows contained in an exception list

I am trying to figure out how to filter a workflow to remove rows which contain specific values (held in an exception list) in one of the columns.

My idea is to hold the exception list in a Text Input tool and somehow connect this to the Filter tool to remove relevant rows.

Thanks in advance for any help or advice.

Jon

Workflow

Preparation

Accepted answers

DataNath

@jpg34 will you always be looking up exact matches, or is it a case of excluding rows that contain key words? If it's the former then you can just conduct a join on the field of interest = your lookup field and then look at the Left output anchor to see those that didn't match like so:

Exclude rows matching lookup list.yxmd

All comments

TimN

Maybe like this...

Testx.yxmd

DataNath

Exclude rows matching lookup list.yxmd

CoG

Sounds like you are looking to use Left/Right Join

@TimN's solution is great if the data is buried in the column (with spaces as the separator), but a simple join will allow you to filter off the values as you were mentioning. I modified the previous solution to include that filtering (with Join tool)

Testx2.yxmd

jpg34

Thanks @TimN . My specific use case is removing rows with exact matches rather than sub-strings but I will no doubt use your logic in the future.

jpg34

Hi Castor

Simple when you know how. Yes this is exactly what I need. Thanks for your time.

jpg34

Hi @CoG

Thanks for your time and adding to @TimN 's solution. Not quite what I need for this use case but will be very handy in the future I am sure.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703