Filter table based on other table

Hi gadao 

You can try the Append Queries feature. Select the table with 10 columns as the primary table and append the other table below it. The append operation is based on the names of the column headers in both tables, and not their relative column position. The final table has all matching columns from all tables appended. If the tables don’t have matching columns, null values are added to the unmatched column. 

I'm not sure how you would like to filter the first table with the second table. With above appended table, if you want to remove the duplicated values in one or some columns, you can select that column (or hold on Ctrl key and select multiple columns) then select Home > Reduce Rows > Remove Rows > Remove Duplicates. If you want to remove duplicated rows, you can select all columns and perform above Remove Duplicates operation. 

If you want to keep the same data which exist in both tables, you can first select Reduce Rows > Keep Rows > Keep Duplicates. Then Remove Duplicates to keep the distinct rows from the remained rows. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.