Set mapping transforms and required values
Use Transform to choose how a source value is passed through, trimmed or normalised for case. Required value determines whether an included row can pass with that value blank.
Provisional sandbox guidance
Before you start
Check representative samples including identifiers with leading zeros, spaces and mixed case.