Client data mapping issue
Ticketclosed
Carnmoor Fleet Leasing · Client data mapping issue
Kofi reported duplicate client records from the leasing system load. Diagnosis showed source data formatting differences in client names. Kofi cleaned the source data and resolved.
What happened
What this says
As at Fri 9 Oct 2026Kofi reported duplicate client records from the leasing system load. Diagnosis showed source data formatting differences in client names. Kofi cleaned the source data and resolved.
Problem: Duplicate client records appeared when loading the full client list, despite unique IDs in the source system. Handling: Connor asked Kofi to verify ID uniqueness and found the issue: client names had inconsistent formatting across sources. The brain matched them as separate records. Kofi identified and cleaned the source data, re-ran the load, and confirmed stable results by 24 Feb 2026. Watch: Good collaborative diagnosis showing the root cause was data quality on the customer side, not a mapping defect.
Details
Updated 9 Oct 26Trail
created · Kofi Asamoah 19 Feb 2026 10:59Hi, We're getting duplicate client records when we load our full client list from our leasing system. Some records are showing as duplicates even though we've only got unique IDs in our source. We need this working properly before we can rely on the brain for our reviews. Is this a mapping issue on our end or something else I should be looking at? Cheers, Kofi- Public reply · Connor Webb 19 Feb 2026 12:25Hi Kofi, Duplicates usually mean either the ID field isn't mapping right, or the source data has actual duplicates that need cleaning. First thing, can you check whether your client_id field is actually unique in your leasing system? Also, roughly how many duplicate records are we talking about? Connor
- Public reply · Connor Webb 23 Feb 2026 15:03Kofi, just following up, have you had a chance to check the ID uniqueness? That'll help us figure out whether it's an issue on your side or if we need to tweak the mapping. Connor
- Public reply · Kofi Asamoah 23 Feb 2026 15:26Yeah, I checked and the IDs are unique in our system. The issue seems to be that our client names have different formatting across different sources, some have initials, some don't. When the brain matches them it's creating duplicates. I'm going to clean up the source data and re-run the load. Cheers, Kofi
- Public reply · Kofi Asamoah 24 Feb 2026 12:41Cleaned the data and re-ran the load this morning. It's looking better now, though I'll keep an eye on it over the next few days to make sure we're getting stable results. Cheers, Kofi
- Status change · 28 Feb 2026 23:59