AX1135

Validating data to be imported before the save

To validate data against lookup columns before performing the save for the import, create a transform step that uses the built-in function Pre-save validation. This function takes no parameters.

This is the same validation process that occurs automatically as part of the actual save for the data import. By performing the validation before the save, you can check for invalid data and abort the process before performing irrevocable data changes in subsequent transform steps (such as deleting old data in the destination table). If instead you want to perform a different custom validation, see Performing custom data validation for an import.

If any destination columns in the import are validated columns, this function validates the data in the temp table against the lookup columns. If exceptions are found, an error message is written to the import log and the import is aborted.

NOTE: If this function is used in an import, then the option to Ignore lookup and key errors does not apply. If invalid data is found in the pre-save validation step, then the import is automatically aborted and does not proceed to the data save.