
Imputation Tool
Version:
2023.1
Last modified: May 17, 2023
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
- Fields to impute: Select the fields you wish to update.
- Incoming value to replace: Specify one of 2 choices.
- Null()
- User specified value: Use the text box to enter a value.
- 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.
- Include imputed value indicator field: Add a field to specify whether or not a value has been imputed.
- 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.