Skip to main content
Solved

Update spreadsheet using FeatureWriter?

  • October 25, 2024
  • 1 reply
  • 70 views
vxn43
Supporter
Forum|alt.badge.img+18

Hello,

I am attempting to use the FeatureWriter to update a spreadsheet. From the screenshot you can see I have Addresses Input into which is pushed 3 updates and 95,393 from the original spreadsheet. The Output port, Addresses adds the 3 records to the original spreadsheet making for 95,396 records. 

Is there a way to get FeatureWriter to update the spreadsheet so the output is 95,393 with the 3 records in 95,393 updated not added to the output? The FeatureWriter is writing to the same spreadsheet in the Addresses Reader. 

 

Best answer by emma.at.safe

Hey @vxn43,

You can use a FeatureJoiner before the FeatureWriter to join the 3 updated rows to those in the original spreadsheet.

To set it up:

  • Connect your original file to the Left input port and the updated file to the Right input port on the FeatureJoiner.
  • In the parameters, set Attribute Conflict Resolution to Prefer Right.

Hope this helps!

Emma

danilo_fme
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

emma.at.safe
Safer
Forum|alt.badge.img+10
  • emma.at.safeSafer
  • Safer
  • Best Answer
  • October 30, 2024

Hey @vxn43,

You can use a FeatureJoiner before the FeatureWriter to join the 3 updated rows to those in the original spreadsheet.

To set it up:

  • Connect your original file to the Left input port and the updated file to the Right input port on the FeatureJoiner.
  • In the parameters, set Attribute Conflict Resolution to Prefer Right.

Hope this helps!

Emma

danilo_fme
vxn43

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.