Deduplicate and geocode 25,077 consignee addresses

Briefing

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.

Liefergegenstand

Clean file plus a change log.

Abnahmekriterien

• Häfen mit UN/LOCODE verknüpft
• Keine doppelten Sendungs-IDs

Erfolgskennzahl

File loads into our BI tool without errors

Ergebnis

File normalised to UN/LOCODE and SCAC; duplicates removed.

Angebote (1)