Have the same issue in FeatureMerger, all remains unmarked. So the data which looks identical and should merge is invisibly different (did trim it)
Question
Change Detect: attributes I am comparing on are not working. Test data is identical data but output is always insert. Original, Revised are different in datatypes, one is varchar50, the other char25? Could that be the reason, how to change the type?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Generally FME determines that two string values match if they look identical, regardless of their data types. Could you please post minimal source datasets and a workspace that reproduce the issue?
The ChangeDetector (or tried Feature Merger) finds about 150 out of 4,500 known ID's (app_d) and owner1 field of interest, which are the same in 2 sets. The ChangeDetector uploads the non matching Insert data to the db. When I then run a standard SQL join Insert to existing data (the Revised data input from db to ChangeDetector) it nicely joins 4,5000 records, where app_d and owner1 are the same in existing (revised data) and Original
