Standardize z-score Tool

The Standardize z-score tool performs a z-score transformation on all the numeric fields in an input data stream. The z-score transformation consists of subtracting the mean value from each of the original values in a field and then dividing this difference by the standard deviation of the field. This results in standardized fields that each have a mean of zero and a standard deviation of one, but are perfectly correlated with the original field values.

Supporting macro location

This is a supporting macro so it does not show in the Tool Palette. You can find it in the following directory: Program Files\Alteryx\bin\RuntimeData\Macros\Predictive Tools\Supporting_Macros

This tool has no parameters that need to be configured.

View the output

  • D anchor: Contains the standardized version of the numeric fields contained in the input stream.
  • P anchor: Contains the fields:
    • Name - The name of each transformed field
    • Mean - The field mean used in the standardization
    • SD - The field standard deviation used in the standardization. This information helps to implement scoring and other similar downstream processing.