Hello,
I am trying to compare changes between 2 excel files containing borehole samples. I am new to the change detector transformer but my understanding is it needs a unique ID to be able to detect Updates but additions and deletions can be detected without one.
My data is a bit irritating as a sample needs to be identified using 4 different fields (Borehole ID, Depth Top, Sample Ref, Sample Type) but when I have these 4 fields selected in the "Update Detection Key Attributes Field" it produces many extra results on a test sample.
Any advice?