Hello everyone! I'm a new FME Desktop user seeking some guidance. I've successfully managed to join tabular data with an existing GIS layer and write the data using the ArcSDE Geodb writer with the "truncate" option to update an existing feature class. Now, I'm looking to automate a new process in FME. Specifically, I want to join a table to a feature class and calculate one of the fields in the feature class using a value from the table I've joined. Is it possible to achieve this without overwriting the entire feature class, only updating the specific field's value? Your insights and assistance would be greatly appreciated!
Several ways to do this:
- FeatureWriter
- Use an AttributeKeeper to only pass the calculated field and the objectid.
- Feature Operation = Update
- Table Handling = Use Existing
- Update Spatial Cokumn(s) = No
- Row Selection, Columns, objectid.
- SQLExecutor easy.
- Do the update using SQL statements, one per feature, where objectid = objectid.
- SQLExecturor advanced.
- Do the update using a SQL statement, one block with all updates.
I would advise new users to use the FeatureWriter, but with really big updates the SqlExecutor might perform better.
+2- Contributor
nielsgerrits wrote:
Several ways to do this:
- FeatureWriter
- Use an AttributeKeeper to only pass the calculated field and the objectid.
- Feature Operation = Update
- Table Handling = Use Existing
- Update Spatial Cokumn(s) = No
- Row Selection, Columns, objectid.
- SQLExecutor easy.
- Do the update using SQL statements, one per feature, where objectid = objectid.
- SQLExecturor advanced.
- Do the update using a SQL statement, one block with all updates.
I would advise new users to use the FeatureWriter, but with really big updates the SqlExecutor might perform better.
Thanks for pointing me in the right direction.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.