Imputation Tool Icon

Imputation Tool

Version:
2021.3
Last modified: August 11, 2021

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.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.