Predict
The Predict function is a general prediction function that modifies the behavior of a prediction such as missing value control, association control, and so on.
Syntax
Predict(<scalar column reference>, option1, option2, ...)
Predict(<table column reference>, option1, option2, ...)
Applies to
Either a scalar column or table column reference.
Return Type
<scalar column reference> or
<table column reference> The return type depends on the type of column to which this function is applied.
Remarks
Possible options include EXCLUDE_NULL (default), INCLUDE_NULL, INCLUSIVE, EXCLUSIVE (default), INPUT_ONLY, and INCLUDE_STATISTICS.
Note INCLUSIVE, EXCLUSIVE, INPUT_ONLY, and INCLUDE_STATISTICS are applicable only for a table column reference, and EXCLUDE and INCLUDE_NULL apply only for scalar values columns.
The following alternative abbreviated forms are often used:
[Gender]is shorthand for Predict([Gender], EXCLUDE_NULL).[Products Purchases]is an alternative for Predict([Products Purchases], EXCLUDE_NULL, EXCLUSIVE_ASSOCIATION).Note The return type of this function is itself regarded as a column reference. This means that this function can be used as an argument in other functions that take a column reference as an argument (except the Predict function itself).
Passing INCLUDE_STATISTICS to a prediction on a TABLE-valued column will add the metacolumns $Probability and $Support to the resulting table. These columns describe the likelihood of existence for the associated nested table record.