Skip to main content
  • EN

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. 

 

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

Reply


Community Stats

30,351
Posts
115,341
Replies
38,082
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.