create aggregated map()
This function is normally inserted and configured automatically when creating special nodes for aggregate maps in the source structure. In most cases, manual adjustment is not necessary, but parameter changes can be made by advanced users.
This function can be used to aggregate the values of fields of a source structure node in a special map (aggregate map). Various aggregate functions are available (→ see parameter a). Let's assume the source structure node occurs three times, then you could, for example, generate the sum of the values of a specific field in this node.
A grouping is also possible with parameter b.
Parameters
Parameter |
Description |
a |
This parameter is used to reference the source structure fields whose values are to be aggregated. The aggregate function to be used for this is also defined here. Available aggregate functions: first(<source structure field index>) - The first occurring value of the source structure field with this index. min(<source structure field index>) - The smallest occurring value of the source structure field with this index. max(<source structure field index>) - The largest occurring value of the source structure field with this index. sum(<source structure field index>) - The sum of all values of the source structure field with this index. avg(<source structure field index>) - The average of all values of the source structure field with this index. count(<source structure field index>) - How many values of the source structure field with this index occur. |
b |
Here you specify the source structure field indexes to be used for grouping. Example: 1,5 |
c |
Name of the aggregate map to be created. |
Example
See section "Special nodes for aggregate maps in source structure".