Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Join 2 lists withou matching the same numbers

nono4
6 - Meteoroid

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:

 

EXPECTED RESULT.png

2 REPLIES 2
Colman_Hendershot
7 - Meteor
 

Desktop Screenshot.png

 

@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. 

binuacs
21 - Polaris

@nono4 one way of doing this

image.png

Labels
Top Solution Authors