Skip to main content

Imputation Tool Icon Imputation Tool

One Tool Example

Imputation has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Imputation to replace a specified value within one or more numeric data fields with another specified value.

A typical use case is to replace all NULL() values with the average of the remaining values for fields Q1_Sales and Q2_Sales so the NULL() values do not affect the final outcome of their forecasting model.

Configure the Tool

  1. Fields to impute: Select the fields you wish to update.

  2. Incoming value to replace: Specify one of 2 choices.

    • Null()

    • User specified value: Use the text box to enter a value.

  3. Replace with value: Specify one of 4 choices.

    • Average: Average of all values, not including Incoming value to replace.

    • Median: Value separating the higher half from the lower half, or the middle value.

    • Mode: Value that appears most often.

    • User specified value: Use the text box to enter a value.

  4. Include imputed value indicator field: Add a field to specify whether or not a value has been imputed.

  5. Output imputed values as a separate field: Leave the original field to impute as-is and add a new field for the imputed value.

View the Output

The default output includes the original data stream with the imputed values embedded within the original data.

  • If Include imputed value indicator field is selected, there is an additional field next to each field selected for imputation with the prefix as the original field name and a suffix of _Indicator.

  • If Output imputed values as a separate field is selected, there is an additional field next to each field selected for imputation with the prefix as the original field name and a suffix of _ImputedValue.

In this section: