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,061
Posts
114,134
Replies
37,685
Members
Terms & ConditionsCookie settings