I have a workspace that was just pulling data and joining schema from two feature classes from an enterprise geodatabase. Then, we had a business need to add two new fields to the output feature class. (I cannot add them to the input feature class). Now, when I run the workspace, it overwrites the edits to those two new fields. Does anyone have suggestions on how to set this up in FME so that the two new fields (flagged and flagged description) aren't overwritten? Here is a screenshot of the workspace. 
Thanks!
Question
Schema change to output feature class
+12- Safer
Hi @jsarthur, do flagged and flagged description both have hard coded values that are the same across all your rows/features? If that's the case, go into the SDE Writer feature type parameters, go to the User Attributes, set the Attribute Definition to Manual, and then set a value in the Value tab.
danminneyatsaf wrote:
Hi @jsarthur, do flagged and flagged description both have hard coded values that are the same across all your rows/features? If that's the case, go into the SDE Writer feature type parameters, go to the User Attributes, set the Attribute Definition to Manual, and then set a value in the Value tab.
Thanks, @danminneyatsafe (Safer) . The values are not hard coded. We want to be able to edit those values on the dataset that's written out from FME. I'm thinking I need to add another input/reader dataset that just contains these two flag fields and merge that into the final dataset. Does that sound like a better solution?
+12- Safer
jsarthur wrote:
Thanks, @danminneyatsafe (Safer) . The values are not hard coded. We want to be able to edit those values on the dataset that's written out from FME. I'm thinking I need to add another input/reader dataset that just contains these two flag fields and merge that into the final dataset. Does that sound like a better solution?
@jsarthur that sounds like the best solution to me. I'd recommend using the FeatureJoiner or FeatureMerger to do so. If you don't have an ID to join on (and want to append the same flagged & flagged description attribute values to each row/feature), then you can use the FeatureMerger and set it up as so:
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.