How to update Person Home Email address via HDL without creating additional Home email records.
Summary
Need to update existing Home email addresses on Person record - replace existing value - without creating additional email recordsContent
I need to do a mass update of person HOME email addresses. I have a working upload, but instead of updating/replacing the existing email address it is creating new records and adding additional Home email addresses. Is there a field that I need to add to the dat file?
Currently the header and data look like this.
METADATA|PersonEmail|DateFrom|DateTo|PersonNumber|EmailType|EmailAddress|PrimaryFlag
MERGE|PersonEmail|2021/08/01|4712/12/31|123456|H1|dummy_Home4@invalidemail.com|Y
The attached image shows hoe current upload is creating additional records which I need to avoid.
3