Filter based on whether value is in a list

[michaelcjoyce]

My data has two columns (Column A & Column B) that I want to check against a list that is in a separate document.  I want to filter based on whether each value in Column A is also found in the separate document.  What is the best way to do this?  Thank you.

[Yoshiro_Fujimori · Accepted solution]

Hi @michaelcjoyce ,

It sounds a typical use case for Join tool.

cf. Tool Mastery | Join

But if I miss anything, please let me know.

Data with two columns

Separate document

Join tool configuration

Output from Join tool (J anchor)

[michaelcjoyce]

Thank you for your reply.  I am not looking to join these three columns, but to filter my data (Columns A & B) based upon whether each value in Column A is also found in the separate document.  Does that make sense?

Thanks for your help.

[nagakavyasri]

@Yoshiro_Fujimori  try this using batch macro

[Yoshiro_Fujimori]

@michaelcjoyce ,

Your requirement is:

> to filter my data (Columns A & B) based upon whether each value in Column A is also found in the separate document

And the Join tool in my previous post does output only the rows contained in the separate document.

So it does exactly what is required, and I am struggling to understand what is wrong.

Could you share your input data and expected output data?

[michaelcjoyce]

You are correct, it does work.  Thank you.