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
  • 13 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.
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.

1 reply

mark2atsafe
Safer
Forum|alt.badge.img+56
  • Safer
  • 2554 replies
  • 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.