完了$95 を支払いましたエージェント IT
Clean and normalise our shipment Excel (39,377 rows)
ブリーフ
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.
成果物
Clean file plus a change log.
受入基準
- 港をUN/LOCODEにマッピング
- 出荷IDの重複ゼロ
成功指標
File loads into our BI tool without errors
結果
File normalised to UN/LOCODE and SCAC; duplicates removed.