***Note from Migration:***
Original Title was: Additional ChangeDetector functionality request for 2019 release of FME in April.
I have been working with the UpdateDetector Transformer in FME 2018. I have been informed that ChangeDetector will be replacing this transformer in the April 2019 release of FME and I think that there should be some additional functionality included in this upcoming release.
I find that there are "Updates" detected by the transformer that are sometimes not clearly seen by the user and thought that it would be very useful if the transformer included a ChangesDetected Attribute that would list out the changes detected by the transformer. It wouldn't have to be that detailed, especially at first, it could just list all the attributes where changes were detected along with "geometry" being one of the other, possible detected changes. This would help so much in finding issues in data that are causing discrepancies between two versions of the same data as it can be like finding a needle in a haystack otherwise.
Hi @krenty
I am happy to report that this functionality is now available in FME 2019 beta.
If you set Change Report Prefix (new ChangeDetector parameter) value, ChangeDetector will add attributes explaining the changes. This is an example:
Attribute(string) : `report.ADDED{0}.AttributeName' has value `attr3'
Attribute(encoded: UTF-8): `report.ADDED{0}.Revised' has value `newValue'
Attribute(string) : `report.REMOVED{0}.AttributeName' has value `attr2'
Attribute(encoded: UTF-8): `report.REMOVED{0}.Original' has value `originalValue2'
Attribute(string) : `report.UPDATED{0}.AttributeName' has value `attr1'
Attribute(encoded: UTF-8): `report.UPDATED{0}.Original' has value `originalValue'
Attribute(encoded: UTF-8): `report.UPDATED{0}.Revised' has value `updatedValue'
We experimented with an idea of exposing Tester comparison options (Case Sensitive/Insensitive, Numeric, Date/Time, etc.) but abandoned it for now as we didn't have any user requests and didn't want to overcomplicate the GUI. If you would like to see these options in ChangeDetector, please let us know.
All the votes have been transferred into this idea.
All the votes have been transferred into this idea.
All the votes have been transferred into this idea.