<< Click to Display Table of Contents >> Navigation:  »No topics above this level« TOC : Script API > JavaScript > JavaScript API > Component > Band > SideBand > Method >   GetDataSetCNT

 

 

Gets the number of dataset rows.

 

 

 

Prototype :

 

double GetDataSetCNT

(

        string DataSetPath,

        [ string DistinctFieldName ],

        [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

 

 

 

Reference :

 

Refer to GetDataSetSUM function for using DistinctFieldName and ConditionFieldName.

 

 

 

Example :

 

//ODI name : Sample, dataset name : Orders

  _TraceLn(This.GetDataSetCNT("Sample.Orders"));

 

//specify DistinctFieldName

  _TraceLn(This.GetDataSetCNT("Sample.Orders", "Region"));

 

//specify ConditionFieldName

  _TraceLn(This.GetDataSetCNT("Sample.Orders", "", "Flag"));

 

//specify DistinctFieldName and ConditionFieldName

  _TraceLn(This.GetDataSetCNT("Sample.Orders", "Region", "Flag"));

 

 

 

Available Events :

 

OnBind,  OnStartBind

 

 

 

See also :

 

GetDataSetSUM