Can I use something similar to update and ERSI File Geodatabase. I am trying to use the fme_db_operation but no data is being updated
Solved
Can I use something similar to update and ERSI File Geodatabase
Best answer by itay
Hi @ian2016, the way you have it set up now means that where the values of rate and weight are the same an update will take place.
I think that it's not what you intend to achieve.
The matched columns is where you usually specify an attribute (such as an id) that exists in the target and input tables.
By leaving only the weight and rate attributes in your writer feature type and using the id in your matched coloumns the update on the target table will take place.
Hope this helps.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi @ian2016, make sure that the writer feature type parameters have been set appropriately for updating the table. The issue could become clear if you posted the screenshot of the Format Parameters tab of your gdb writer feature type.
doc1.pdfHi Takashi, I attach a screenshot. I am trying to update Weight and Rate attributes for all rows in the table. I also get an error when I try to update a Score attribute (calculated from the new Weight and Rate - "attribute has been dropped"). Thanks for your help. The script appears to run successfully.
doc1.pdfHi Takashi, I attach a screenshot. I am trying to update Weight and Rate attributes for all rows in the table. I also get an error when I try to update a Score attribute (calculated from the new Weight and Rate - "attribute has been dropped"). Thanks for your help. The script appears to run successfully.
+18- Supporter
- Best Answer
Hi @ian2016, the way you have it set up now means that where the values of rate and weight are the same an update will take place.
I think that it's not what you intend to achieve.
The matched columns is where you usually specify an attribute (such as an id) that exists in the target and input tables.
By leaving only the weight and rate attributes in your writer feature type and using the id in your matched coloumns the update on the target table will take place.
Hope this helps.
Hi @ian2016, the way you have it set up now means that where the values of rate and weight are the same an update will take place.
I think that it's not what you intend to achieve.
The matched columns is where you usually specify an attribute (such as an id) that exists in the target and input tables.
By leaving only the weight and rate attributes in your writer feature type and using the id in your matched coloumns the update on the target table will take place.
Hope this helps.
Thanks, as you say not understanding what was needed, I added the object id to the match columns and removed Weight and Rate