Skip to main content
Question

Change Detector without unique ID

  • September 8, 2020
  • 3 replies
  • 49 views

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?

3 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • September 8, 2020

Is the combination of the 4 different fields unique for a sample?

 

 "when I have these 4 fields selected in the "Update Detection Key Attributes Field" it produces many extra results on a test sample"

I'm not sure exactly what you mean by the above statement. Can you explain?

 

 


  • Author
  • September 8, 2020

No unfortunately. The final 2 fields are the fields that need checking for updates but there can be multiple instances of the initial 2 fields.


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • September 8, 2020
rjwillshear wrote:

No unfortunately. The final 2 fields are the fields that need checking for updates but there can be multiple instances of the initial 2 fields.

Ok, in that case you need to be aware that the order of the features affects what 'changes' are detected. Try sorting both inputs in the same way. I'd then use your first two fields as your key attributes, with the other two as the attributes to check

https://community.safe.com/s/question/0D54Q000080hHoC/changedetector-how-are-duplicate-update-detection-key-attributes-handled


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