AX2438

Import Wizard: Transforms tab

The Transforms tab of the Import Wizard contains a set of statements to perform actions on the data in the temp table, in order to transform the data before saving it to the destination table.

When the import is executed, the transforms are processed after import variables have been selected and after the data query has been made to the source table or file. Transforms are processed in the order listed in the tab.

Transforms can use SQL statements or built-in Axiom transform functions.

Managing transforms

• To add a transform, click Add transform . The new transform is added below the row that is currently selected.

• To duplicate a transform, select the row that you want to duplicate and then click Duplicate selected transform .

• To edit a transform, make changes directly in the grid.

• To delete a transform, select the row that you want to delete, and then click Remove transform .

• To change the order of transforms, select the row that you want to move and then use the arrow icons to move it up or down.

The following settings are defined for each transform:

Field	Description
Number	The ordinal number assigned to each transform, to determine processing order. This setting is managed by Axiom Software. When you change the order of rows, Axiom Software automatically changes the order number.
Transform	A SQL statement, or a built-in Axiom import function. To define the transform, double-click the field or click the browse button (...) in the field. The Edit Transform dialog opens so that you define the transform. See Defining transform statements.
Description	Displays the description of the transform. This is for reference only. You can define this description when defining the transform.
Target Variable	Displays the name of the target variable for the SQL transform. For SQL statements, target variables are defined when editing the statement. Target variables do not apply to import functions. See Defining transform statements.
	Select the Pause check box if you want the import to pause and display the temp table after processing this transform. This option only applies when executing the import in development mode, using the option Pause after specified transforms and display current temp table data. For more information, see Executing imports in development mode.
	Select the Disable check box to disable the transform. When the import is processed, this transform will be skipped.

Transform notes

If the import contains a transform that zeroes old data before importing the new data, the Pre-Save Validate function should be used before the zero step. This allows you to identify any data issues before deleting existing data. If invalid data is found, the import is aborted and the zero step will not be processed.