Defining parameters for a Clean Data transformer

These steps are part of the larger task of Cleaning data. When you complete these steps, click the link at the bottom of the panel to return to the main task.

To define parameters for a Clean transformer:

1. Right-click anywhere on the Transformer definition table and select Add. A row is added to the table.

2. Under the Input column heading in the row that you just added, click and select the name of the column that contains the data that will be cleaned.

3. In the Clean type list, select the type of clean transformation that will be performed on the input column when the step runs.

   To copy your input column to the target table without making any changes, click Carry Over. The Rules list and Parameter list are not available. Proceed to step 7.

4. In the Rules list, click to specify the rules table that the step will use for the clean type that you selected. A window opens. The fields on the window vary depending on the selection you made. Use this window to define rules for the clean type that you selected:

   • Define rules for Find and replace

   • Define rules for Discretize

   • Define rules for Clip

5. In the Parameters column, click .

   Depending on the data type of the column that you specified in the Input column field, either the String Parameters window or the Numeric Parameters window opens:

   • Specify information about string parameters - Use the controls in the String Parameters window to customize how the Clean Data transformer performs the find and replace tasks.

   • Specify information about numeric parameters - Use the controls in the Numeric Parameters window to specify a numeric tolerance for your transformation.

6. Repeat steps 1 through 6, as appropriate.

Return to Cleaning data.