Filter based on whether value is in a list

My data has two columns (Column A & Column 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.

Common Use Cases

Accepted answers

Yoshiro_Fujimori

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)

Join.yxmd

All comments

Yoshiro_Fujimori

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)

Join.yxmd

michaelcjoyce

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

Thanks for your help.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280