Export (0) Print
Expand All

PredictNodeId (DMX)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the Node_ID of the node to which the case is classified.

PredictNodeId(<scalar column reference>)

A scalar column.

<scalar expression>

The following example returns whether the specified individual is likely to buy a bicycle, and also returns the nodeID of the node that they are most likely to be part of.

SELECT
  [Bike Buyer],
  PredictNodeId([Bike Buyer])
From
  [TM Decision Tree]
NATURAL PREDICTION JOIN
(SELECT 28 AS [Age],
  '2-5 Miles' AS [Commute Distance],
  'Graduate Degree' AS [Education],
  0 AS [Number Cars Owned],
  0 AS [Number Children At Home]) AS t

You could then use the following statement to determine what is contained within the node:

SELECT 
  NODE_CAPTION 
FROM 
  [TM Decision Tree].CONTENT
WHERE NODE_UNIQUE_NAME= '00000000100' 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft