Skip to main content

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