Westfield London
Merge Customers
Merge two duplicate customer records into one. The source record will be deleted.
Source record (will be deleted)
Source
John Smith
john.smith@gmail.com
Phone: +44 7700 111222
DOB: 1979-06-12
Joined: 2023-09-05
ID: EXT-10007
Tier: Silver
Points: 620
Transactions: 8
Status: active
Target record (will survive)
Target
John Smith
johnsmith1979@hotmail.com
Phone: +44 7700 333444
DOB: 1979-06-12
Joined: 2024-01-18
ID: EXT-10008
Tier: Bronze
Points: 135
Transactions: 3
Status: active
Field Comparison
| Field | Source | Target |
|---|---|---|
| First Name | John | John |
| Last Name | Smith | Smith |
| john.smith@gmail.com | johnsmith1979@hotmail.com | |
| Phone | +44 7700 111222 | +44 7700 333444 |
| Date of Birth | 1979-06-12 | 1979-06-12 |
| Gender | male | male |
| Join Date | 2023-09-05 | 2024-01-18 |
| External ID | EXT-10007 | EXT-10008 |
| Status | active | active |
| Points Balance | 620 | 135 |
| Tier | Silver | Bronze |
| Acquisition Channel | in-store | app |