Skip to main content
Solved

Update spreadsheet using FeatureWriter?

  • October 25, 2024
  • 1 reply
  • 45 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 emmaatsafe

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

View original
Did this help you find an answer to your question?

1 reply

emmaatsafe
Safer
Forum|alt.badge.img+8
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings