Joining Tables in ArcGIS Pro

This video was made to help a student who was getting null values when peforming a join. The problem was FIPS fields in the Tracts feature layer and in data table CSV file appeared to have identical values but still would not join properly. The problem was caused due the respective FIPS fields were not the same data type. The Tracts table had FIPS set to Text, while the CSV table had FIPS set to Double. This video demonstrates how to remedy this issue and create a successful join.

[@slt5431]

This video makes me feeling hope again, because I was struggle to join the table for the past few weeks. Thank you for the detail explanation

[@katepeng3774]

Thank you so much for this video. It is a life saver to me!
p.s. For people who lost in translation on the following error message: "000970: The join field in the join table is not indexed. To improve performance, we recommend that an index be created for the join field in the join table", the most straight forward answer is right here!

[@jedi_mapperp4073]

Thank you. Please like and subscribe so others find this video. I made it for one of my students. Glad you found it useful.

[@katepeng3774]

@@jedi_mapperp4073 I already subscribed your channel. Thank you for sharing.

[@samjones6661]

Thanks a lot. Many videos are like: you have a layer and a table, just add join and you are fine. Your video is like: Before you add join make sure they have the same data type. After this go for it ... and it magically worked :)

[@jedi_mapperp4073]

Yep. I noticed the same thing so I made a video for my student(s). It made me realize many GIS users can click buttons but don’t understand much below the surface. Understanding first principles of tabular, vector, and raster data are key. Same for map projections and setting up Geodatabases so all the data is in the same projection. If not…everything crashes, or looks good “on the fly” but the spatial analysis tools crash. Many don’t understand why.

[@jeremiahladucapro]

BY FAR THE MOST HELPFUL VIDEO ON THE INTERNET FOR JOINING FIELDS! THANK YOU!

[@jedi_mapperp4073]

Thank you! Share it around. I’m retired now. Pretty cool feeling seeing my videos are still teaching. 👍

[@dunkman206]

This video was extremely helpful with a project I am working on, I greatly appreciate you creating this video!

[@jedi_mapperp4073]

Glad it helped. If you need help in the future let me know. If I can help I make a video.

[@noegaray7088]

I was having trouble with this same issue for a capstone project I'm working on. I greatly appreciate the time you took in making this video!

[@jedi_mapperp4073]

You’re welcome. Glad it’s still applicable as ESRI changes the software so often.

[@chisatotarui9396]

YES!!! THANK YOU!!! MOSZT HELPFUL VISDEO EVER I LOVE YOU!!!! *aggressive virtual handshake*

[@jedi_mapperp4073]

Well alright alright…aggressive virtual You’re welcome!! 😀

[@jackiec7284]

THANK YOU SO MUCH！you solved my problem right before my assignmenr due！your video is really helpful！！

[@elijahdavis1175]

My savior thank you so much

[@SarinaVega-q4u]

LIFE SAVER

[@user-ey4rc5tu4t]

Ok. You are joining. Not merging. Interesting.

[@jedi_mapperp4073]

You add tabular data to an existing layer feature by joining tables. You can merge two features with identical attribute tables.