Joining tables

419
4
07-12-2018 02:18 PM
SLouq
by MVP Regular Contributor
MVP Regular Contributor

I have an Excel Spreadsheet that is being updated daily and would like to map that spreadsheet to a feature class. The spreadsheet has an ID field in it (#09-09, etc.) . . . but can I create an ID field in the Feature Class table to Join with or will the data types prevent me from doing that?

0 Kudos
4 Replies
DanPatterson_Retired
MVP Emeritus

You can add a field to your table to match and in Pro, there is even a field calculator autoincrement ..

You can even snag the field calculator code here.

Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop 

in the ...

Accumulative and sequential calculations

section

SLouq
by MVP Regular Contributor
MVP Regular Contributor

Will this work in ArcMap 10.2

0 Kudos
SLouq
by MVP Regular Contributor
MVP Regular Contributor

I guess another way to ask the question I have is.

Is there a way to populate an attribute table with records from an Excel Spreadsheet which doesn't have a Lat and Long field through the Field Calculator

0 Kudos
DanPatterson_Retired
MVP Emeritus

Joins work.  The excel table doesn't need coordinates, it only needs a field which matches (name doesn't need to be the same) the file which has the geometry

0 Kudos