Skip to main content
Question

Is it possible to use a dynamic writer to update? I want to read multiple feature classes, join each feature class and then update the joined records in a different database. Matching columns are not available when selecting Update feature opera

  • September 1, 2020
  • 1 reply
  • 9 views

Forum|alt.badge.img
Is it possible to use a dynamic writer to update? I want to read multiple feature classes, join each feature class and then update the joined records in a different database. Matching columns are not available when selecting Update feature operation.

1 reply

mark2atsafe
Safer
Forum|alt.badge.img+43
  • Safer
  • September 3, 2020

Yes this is possible. You're right, the attributes wouldn't be available on the writer parameters because the dynamic writer doesn't know what they're going to be until runtime.

So I think you have two choices:

  • Manually expose the attributes using the AttributeExposer transformer
  • Instead of picking the attributes, make a where clause in an attribute (like myWhereClause: myAttribute = myFieldName) and use that as a WHERE clause instead of a Match Column

Hope this helps.


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