Skip to content

Latest commit

 

History

History
44 lines (33 loc) · 1.26 KB

File metadata and controls

44 lines (33 loc) · 1.26 KB
title IsInNode (DMX)
description IsInNode (DMX)
author minewiskan
ms.author owend
ms.reviewer owend
ms.date 02/17/2022
ms.prod sql
ms.technology analysis-services
ms.topic reference
ms.custom dmx

IsInNode (DMX)

[!INCLUDEssas]

Indicates whether the specified node contains the current case.

Syntax

  
IsInNode(<NodeID>)  

Return Type

A Boolean type.

Remarks

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

Examples

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)