Aggregate Functions

Top Previous Topic Next Topic  Print this topic

Aggregate functions are functions that compute values over all data source records.

 

In the sample below are listed all supported aggregate functions:

 

count-function - returns the number of records in a data-set.

max-set-function - this function starts an iteration over the specified data source and computes the max value of the referenced source from in-param

min-set-function - same as max-set-function only it computes min value.

average-set-function - same as max-set-function only it computes average value from the specified source.

sum-set-function - same as max-set-function only it computes sum value from the specified source.

 

Note. A comprehensive sample using aggregate functions can be found in Samples\Job Samples folder.

 

 

<das:count-function id="1c" data-source="a">

       <das:return-value id="1d"/>

</das:count-function>

 

<das:max-set-function id="10" data-source="a">

       <das:in-param id="12" src="c"/>

       <das:return-value id="11"/>

</das:max-set-function>

 

<das:min-set-function id="13" data-source="a">

       <das:in-param id="15" src="c"/>

       <das:return-value id="14"/>

</das:min-set-function>

 

<das:average-set-function id="16" data-source="a">

       <das:in-param id="18" src="c"/>

       <das:return-value id="17"/>

</das:average-set-function>

 

<das:sum-set-function id="19" data-source="a">

       <das:in-param id="1b" src="c"/>

       <das:return-value id="1a"/>

</das:sum-set-function>

 

 

Attributes:

id - unique identifier of this resource in the current processing job.

data-source - input data source.

 

Children elements:

<das:in-param> - irrelevant for count-function, otherwise mandatory.  Specifies the source over which min, max, average or sum values are to be computed.

<das:return-value> - specifies the id from which the result value of the function will be referenced in the current job.