|
Functions and Set Functions |
|
|
Functions and Set Functions |
|
In most cases, the data must be modified or transformed before aggregation.
In order to operate on existing data, Data Architect provides functions and set functions. Functions operate on fields, while Set Functions operate on data sources.
Some examples of Functions:
| • | Constant: a special type of function; has no input, output is a value of a selectable type |
| • | Sum: typical sum; has at least 2 input parameters of type number, output is a number value representing the sum of the input parameters |
| • | Equal: comparison; has at least 2 input parameters, output is a Boolean value indicating whether any 2 input parameters are equal to each other |
Some examples of Set Functions:
| • | Sort: sorts a data source by a given rule; input is a data source and a field indicating the rule to sort by, output is the sorted version of the input data source |
| • | Join: joins two data sources using a given condition (similar to SQL Join); input are the parent and child data sources plus the join condition, output is a data source representing the join result |
| • | Group By: groups a data source using a grouping rule (similar to SQL Group By); output is the grouped result and the key for each entry in the result data source |