Deduplicate and geocode 8,646 consignee addresses

Resumen

Our shipment export has 8,646 rows with mixed port names, carrier names and dates. Normalise to UN/LOCODE, SCAC and ISO dates, remove duplicates.

Entregable

Clean file plus a change log.

Criterios de aceptación

• Puertos vinculados a UN/LOCODE
• Cero identificadores de envío duplicados

Métrica de éxito

File loads into our BI tool without errors

Propuestas (1)