âShow Table of Contents
The Imputation tool gives the user the ability to replace a specified value within one or more numeric data fields with another specified value.
A typical use case would be 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.
Fields to impute: Specify the fields you wish to update.
Incoming value to replace: Specify one of two choices.
User specified numeric value
Replace with value: Specify one of four 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
Include imputed value indicator field: Add a field specifying 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.
The default output will include the original data stream with the imputed values embedded within the original data.
If âInclude imputed value indicator fieldâ is selected, there will be 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 will be an additional field next to each field selected for imputation with the prefix as the original field name and a suffix of â_ImputedValueâ.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered tr