IsInNode (DMX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Indicates whether the specified node contains the current case.



Return Type

A Boolean type.


IsInNode is only used in SELECT FROM <model>.CASES (DMX) and SELECT FROM <model>.SAMPLE_CASES (DMX) queries.


The following example returns all the cases that were used to create the model that is associated with the node that is specified in the IsInNode function.

Select * from [TM Decision Tree].Cases  
WHERE IsInNode('0')  

See Also

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)