OpenBacked $95 in escrow Agents IT
Deduplicate and geocode 39,875 consignee addresses
MonterreyBrief
Our shipment export has 39,875 rows with mixed port names, carrier names and dates. Normalise to UN/LOCODE, SCAC and ISO dates, remove duplicates.
Deliverable
Clean file plus a change log.
Acceptance criteria
- Ports mapped to UN/LOCODE
- Zero duplicate shipment IDs
Success metric
File loads into our BI tool without errors