Skip to main content
Solved

set update key field from attribute value


esietinga
Contributor
Forum|alt.badge.img+4

Is it possible to set the Update Key Field in de ArcSDE Geodatabase writer from an attribute value?

I am trying to build e dynamic workbench to update features in an ESRI SDE Geodatabase. I set my writer in update mode and set fme_db_operation in the workbench. The datasets to process are fed to a featurereader from an csv file.

My incoming dataset (67 datasets in total) has an attribute containing the name of the primary key column. This name is not constant for all tables which have to be updated. I have come across using the fme_where attribute but are not sure of the syntax to be used. From the data in my incoming tables I can build something like: fme_where='Primary_key=1'

Best answer by erik_jan

I believe this should work: fme_where='@Value(Primary_key)=@Value(@Value(Primary_key))'

The first part will extract the contents of the Primary_key attribute, the second will take that attribute name and take the value of the attribute.

View original
Did this help you find an answer to your question?

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • June 22, 2017

I believe this should work: fme_where='@Value(Primary_key)=@Value(@Value(Primary_key))'

The first part will extract the contents of the Primary_key attribute, the second will take that attribute name and take the value of the attribute.


kimo
Contributor
Forum|alt.badge.img+10
  • Contributor
  • December 4, 2017

I wish this was in the Help for dynamic writers...


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings