Hello,
All my data is in Excel spreadsheets. All the schemas are the same.
I have two readers:
The Updates Reader includes the 3 records that have been changed. These 3 records already exist in the Address Reader spreadsheet.
The Address Reader is the original spreadsheet that includes these 3 records before they were updated.
I would like these updates written to the Addresses Writer which creates a new excel spreadsheet with the 3 records updated but no new records added.
In my workbench here, I run it, and the results are the 3 records are added to the 95,393 thus the new spreadsheet has 95,396 records in it. Having the 3 records added results in having 6 duplicate records whereas previously there were no duplicate records. I need the Addresses output to be 95,393 records with the 3 records I mention previously updated.
I have tried changing all the parameters in the Writer with no success. The results are always the same, 95,396.
I know I can use FeatureJoiner/FeatureMerger, but is there another method I can use?
What am I missing? can someone tell the exact parameter combination to make this work?