Join 2 lists withou matching the same numbers

Question

Please, help!

I need to join to 02 lists, matching Country and Category, but I cant repeat the result of the join, I need only 1 position number, 1 Position Description and 1 Yes/No per join.

So, I need to look into a database, and find one result per join, without repeating the matches.

Follow the example in the image bellow:

Join 2 lists withou matching the same numbers.yxmd

binu_acs · Answer

@nono4 one way of doing this

Join 2 lists withou matching the same numbers.yxmd

Colman_Hendershot · Answer

@nono4  You will need to add a sort and then a unique tool (selecting all fields) to get the end result you are looking for.