← Back to Data Studio

Convert Department from Text to Date

Data Domain: Finance & administration · DRAFT only. The original source values stay unchanged. Only the normalized values are converted. Review ambiguous values before applying.

EmployeeCurrent valueAnalysisCanonical date (ISO)
EMP-1005Sales invalid
EMP-1008Finance invalid
EMP-1001Finance invalid
EMP-1006IT invalid
EMP-1007Operations invalid
EMP-1004HR invalid
EMP-1003Operations invalid
EMP-1002IT invalid

Invalid dates must be corrected in source data and re-imported before conversion. No guessing and no partial migration.