How to created an "inner join"" relationship between two tables.

I have two data tables in an analysis. They share same row keys so I created a relationship between them. But both of them still has all rows from sources. I am trying to filter out rows which are not existed in the other table and keep only the rows existed in both table.

Is it possible to create an "inner join" relationship and filter out useless rows for both tables.

Thank you very much.

(5) Answers