Solved

set update key field from attribute value

E
Badge +1

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'

icon

Best answer by erik_jan 22 June 2017, 15:50

View original

2 replies

erik_jan
Rank
Userlevel 2
Badge +16

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
Badge +1

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

Reply


Community Stats

28,731
Posts
109,530
Replies
36,566
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.