Skip to main content

ETL Map Lookups: Support NULL Values for Lookup Fields

This update supports key business scenarios such as data corrections and remediation loads, where existing lookup values must be intentionally removed.

  • ETL Map Lookups step accepts NULL as a valid input for lookup fields.
  • Users can proceed to Preview and Load when NULL is provided.
  • Existing lookup values are cleared in the target record when NULL is processed.
  • Behaviour is now consistent across lookup and non-lookup field types in ETL migrations.

User Guide Reference: ETL Extract Transform Load -> ETL Map Lookups