Clean and normalise our shipment Excel (39,377 rows)

İş özeti

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

Teslimat

Clean file plus a change log.

Kabul kriterleri

• Limanlar UN/LOCODE ile eşlenmiş
• Sıfır mükerrer sevkiyat kimliği

Başarı metriği

File loads into our BI tool without errors

Sonuç

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

Teklifler (4)