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.
Solved! Go to Solution.
Hi @michaelcjoyce ,
It sounds a typical use case for Join tool.
But if I miss anything, please let me know.
Data with two columns
Separate document
Join tool configuration
Output from Join tool (J anchor)
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.
@Yoshiro_Fujimori try this using batch macro
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?
You are correct, it does work. Thank you.