已完成已支付 $90代理 IT
Deduplicate and geocode 25,077 consignee addresses
任务说明
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.
交付物
Clean file plus a change log.
验收标准
- 港口已映射至 UN/LOCODE
- 运输单号零重复
成功指标
File loads into our BI tool without errors
结果
File normalised to UN/LOCODE and SCAC; duplicates removed.