06-22-2023 05:33 AM - edited 06-22-2023 08:57 AM
For merging records using Dedupe in DemandTools V, I am trying to preserve an alternate mobile number if available. For example, if the mobile number is 999-999-9999 for the winner record and 111-999-9999 for the child record, I want 111-999-9999 to populate in an Alternate Mobile Phone field. I think FieldCopyUnique within Field Rules is designed for this purpose, but cannot find any helpful documentation.
I have tried testing FieldCopyUnique functionality for this purpose by setting the RULE OVERRIDE = FieldCopyUnique for the alternate mobile field I am trying to populate, and VALUE equal to the Mobile Phone field. When trying to merge two records with differing Mobile Phone values, this field rule setup does not carryover the child Mobile Phone value to the Alternate Mobile Phone field.
Any ideas or documentation for how to implement FieldCopyUnique in the correct manner? Thank you for any contributions!
06-26-2023 07:54 AM
Have you seen this documentation? Single Table Dedupe - Field Rules
06-28-2023 01:04 PM
Hi @mastratt, it sounds like you are configuring it properly in the Field Rules section - I will point out that DemandTools will not overwrite any data that may already exist in the Alternate Phone field if it is already populated, unless you choose FieldCopyUnique Overwrite.
If this still isn't working properly at this time, I would highly suggest opening a support ticket through this link.
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog