Updating Feature Class Using Excel Worksheet with Different Schema

Question

Hey all,

I have a feature class for Capital Projects that are occurring throughout our city. I am needing data (financial information) updated for these Capital Projects without having to manually update each project. These projects are identified using a unique "Program Code."

The data from our Financial Management Software (FMS) exports the data in a non-GIS friendly Excel document.

Is there a way to update the data in our Capital Projects feature class with the data from the FMS Excel document?

See attached Excel docs as an example.

FeatureClass_Example.xlsx

FMS_Export_Example.xlsx

rzufelt · Accepted Answer

Depends on if you want to transfer all the data columns from the excel worksheet, or just update the empty columns.

You can use Add Join using your common ID field to create a temporary join to the table, then calculate the columns you want using joined table.

You can also use Join Field using your common ID field and it will append the joined columns to the feature class table.

R_