Compare two files and keep matches of only one file

[T_Lina]

Dear Alteryx community, 

I have two files that I want to compare: File A and File B. I want to compare them on one column.

As an output I would like to see all records from File B that match File A on this common column. 

I have already used the Join-Tool, but as an output I get the matching records from both File A and File B. 

However, I would only like to see what records matched in File B. 

Can you help me with that?

Thanks a lot in advance. 

BR

[Rumanais]

I just used this solution for the similar problem described in this post and worked perfectly! The Join tool may have additional benefit, but for this type problem, I think this tool is the best.

Thank you

[Rumanais]

Hi Emil_Kos,

Can you please create some simple workflow with the solutions you suggested?  That way it would be easier to understand the solutions you are suggesting.

Thank you!