topic Re: Workflow Advice in Geoprocessing Questions

Workflow Advice

BrianLeroux — Fri, 30 Mar 2012 13:44:08 GMT

I am looking for a way to automate a process of updating a layer from a table. I have my CIS dept updating an SQL table (Claims) in my SDE database which does not have any spatial attributes. I have a feature class (Customers) which has an matching key to that table. Is there a way to create and update a Claims feature class from the joined tables? This would be something that would run every 30 minutes when the new claims data is added to the claims table. I have been experimenting with a workflow in Catlog but can't seem to come up with the right combination of tools. Any help is appreciated.

Thanks!

Re: Workflow Advice

MathewCoyle — Mon, 02 Apr 2012 13:36:02 GMT

I would think this could be better accomplished outside of Arc. Using some backend SQL or tableviews that runs on a schedule. If you are tied to Arc tools, you can give Join Field a try. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000065000000

Re: Workflow Advice

BrianLeroux — Mon, 02 Apr 2012 19:27:42 GMT

Thanks Mathew. I did end up using a join and it seems to be working properly. I appreciate your input.