Find a match between 3 data sets

Question

Hi Everyone,

Appreciate this is probably a lot more straightforward than I think. I have 3 separate data sets. All of which have 1 field in column in common which is "ID".

Is there a way in which i can see what ID's appear in all 3 data sets?

Regards,

Shane

grazitti_sapna · Answer

Hi @ShaneB19,

You can make use of the join multiple tool as shown in the example below:

I hope this is what you are looking for.

join_Multiple.yxmd

kelsey_kincaid · Answer

Hi @ShaneB19 ,

The Join Multiple tool would work well for this. I've attached a sample workflow - let me know if it works for your use case!

Join Multiple.yxmd

Christine_Assaad · Answer

Hi @ShaneB19

Please check the attached. It will give you an idea on how this could be achieved. Thanks!

Common ID.yxmd