Select Numeric Scheme

Select the transformation for selected attribute from the dropdown list, and enter any necessary values. For example, if you select LN(x + a), you must specify a value for a. Note the restrictions on scheme values; for example, if you select LN(x + a), the value of a must be such that x + a > 0 for all values of the attribute.

The wizard displays statistics for the Original values and the Transformed values. Initially, both sets of statistics are the same. To see statistics for transformed values, select a transformation and click Refresh.

When you are satisfied with the scheme definition, click OK to apply the scheme. You can click Cancel to cancel the scheme selection.

You can select one of the following predefined schemes:

Note: The functions (EXP, LN, etc.) in the schemes use the notation of the SQL functions; for definitions, see Numeric Functions in Schemes.

To see the effect of the transformation immediately, click Refresh.

Click OK to select the scheme.