Find a match between 3 data sets

[ShaneB19]

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

[christine_assaad]

Hi @ShaneB19 

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

[kelsey_kincaid]

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!

[grazitti_sapna]

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.