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?
Solved! Go to Solution.
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?
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.
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?
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.