Select to view content in your preferred language

Joining a excel table to feature class

403
2
Jump to solution
11-14-2024 12:07 PM
DevarsiMajumder
Occasional Contributor

Hello there

I am trying to add some new fields from an Excel sheet to a new feature class. The Excel file already has the new fields built in, and I was wondering if there is a way that I can join that table to the feature class without having a common ID field. Or do I need to build a common field in Excel to join the feature class? Can I just add the four fields from Excel to the feature class?

0 Kudos
2 Solutions

Accepted Solutions
clt_cabq
Frequent Contributor

does your excel data have any coordinate information? you could try doing something spatial, but that may end up not working real well if the coordinate data aren't quite right. Your best approach is to spend the effort to create some sort of linking field in the excel table I think otherwise there is just no real way to connect common rows between data sources. How are you able to know which row in excel belongs to which row in your feature class?

View solution in original post

0 Kudos
DevarsiMajumder
Occasional Contributor

Yeah I decided to put all the fields in one feature class and then  make view layers and turn on and turn off certain fields that  are not needed to be seen.  I figured that was the best  solution to my issue.

View solution in original post

2 Replies
clt_cabq
Frequent Contributor

does your excel data have any coordinate information? you could try doing something spatial, but that may end up not working real well if the coordinate data aren't quite right. Your best approach is to spend the effort to create some sort of linking field in the excel table I think otherwise there is just no real way to connect common rows between data sources. How are you able to know which row in excel belongs to which row in your feature class?

0 Kudos
DevarsiMajumder
Occasional Contributor

Yeah I decided to put all the fields in one feature class and then  make view layers and turn on and turn off certain fields that  are not needed to be seen.  I figured that was the best  solution to my issue.