Skip to main content
  • EN

I have two spreadsheets. One is the original data; the other is data that has changed. The schemas are the same. The spreadsheet with the changes has 3 records. 

I need to add these 3 records into the original data (while deleting the original 3 records in the original data), thus updating the records in the original. 

What is the best way to do this using ChangeDetector?

Currently, when I use ChangeDetector, the records from the changes spreadsheet are output to Inserted; The records from the original spreadsheet are output to Deleted. Deleted includes the 3 unchanged records that are in changes spreadsheet. 

 

In the screenshot below the 95,392 in Deleted include the unchanged records that are in Changes. The transformer outputs the Original and Revised separately with no way for me to delete the 3 records in 95,392 and add the 3 changed records?

 

You probably don’t need the change detector here, since your changes are already identified (the 3 records in the original). What output format are you writing to? Depending on this, you may just need to send the changed records as updates to the writer.

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
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.