Deduplicate and geocode 25,077 consignee addresses

Brief

Our shipment export has 25,077 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

Proposals (0)

No proposals yet. Be the first.