This topic has not yet been rated - Rate this topic

PredictNodeId (DMX)

SQL Server 2008

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


PredictNodeId(<scalar column reference>)

Applies To

A scalar column.

Return Type

Examples

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'

Reference

Data Mining Extensions (DMX) Function Reference

Functions (DMX)

Mapping Functions to Query Types (DMX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD