topic Re: Updating Feature Class Using Excel Worksheet with Different Schema in ArcGIS Pro Questions

Updating Feature Class Using Excel Worksheet with Different Schema

JoshBillings — Tue, 23 Aug 2022 14:21:45 GMT

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.

Re: Updating Feature Class Using Excel Worksheet with Different Schema

RhettZufelt — Tue, 23 Aug 2022 21:01:05 GMT

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.

Re: Updating Feature Class Using Excel Worksheet with Different Schema

JoshBillings — Thu, 25 Aug 2022 14:47:08 GMT

Thanks Rhett!