DecisionTreePredict Function Example | Teradata Vantage - DecisionTreePredict Example: OutputProb, Responses - Teradata® Database

Input

See DecisionTreePredict Examples Input.

SQL Call

SELECT * FROM DecisionTreePredict (
  ON iris_attribute_test AS AttributeTable PARTITION BY pid
  ON iris_attribute_output AS Model DIMENSION
  USING
  AttrTableGroupByColumns ('attribute')
  AttrTablePIDColumns ('pid')
  AttrTableValColumn ('attrvalue') 
  OutputProb ('true')
  Responses ('1','2','3')
) AS dt ORDER BY pid;

Output