Home >

AX1133

Performing custom data validation for an import

To exclude rows of data from an import based on a custom criteria, create a transform step that uses the built-in function Custom data validation. Any data in the temptable that matches the specified filter will be excluded from the save.

This custom validation is separate from the built-in lookup validation that occurs as part of the data save (or by use of the Pre-Save Validate function).

Function parameters

Parameter	Description
Filter	A filter used in the SQL WHERE clause against the temp table. Any rows that match this filter are excluded from the save, and will be reported in the import error log with any other validation errors.
Failure Message	An error message to display next to records that are excluded due to this data validation step. Errors are logged in a column named AXTRANSFORM_StepNumber, where StepNumber is the number of the associated transformation step. For example: "AXTRANSFORM_5" when the associated transform is step 5 in the list.

For example, you might want to check to make sure that data exists in a particular column of the temptable before importing that record. If the necessary data is missing, then that record will be excluded from the import. In this case the function settings would be something like the following: