Workflow Advice

326
2
Jump to solution
03-30-2012 06:44 AM
BrianLeroux
Regular Contributor
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!
0 Kudos
1 Solution

Accepted Solutions
MathewCoyle
Frequent Contributor
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

View solution in original post

0 Kudos
2 Replies
MathewCoyle
Frequent Contributor
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
0 Kudos
BrianLeroux
Regular Contributor
Thanks Mathew. I did end up using a join and it seems to be working properly. I appreciate your input.
0 Kudos