Reducer Processor - EcoSys - 3.1 - Help - Hexagon

EcoSys Connect Help

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
3.1

Reducer processor supports:

  • Aggregation functions such as Count, Avg, Sum, Min, and Max.

  • Grouping of columns

  1. Enter the values for the following parameters in the Basic section.

    1. Name – Specify the name

    2. Aggregate Expressions – Aggregation functions such as Count, Avg, Sum, Min, and Max.

      For example, Reducer process configured to produce the Min and Max Start Date.

Previous Step Entity Set

Project ID

Period

1

1/2018

2

1/2019

3

1/2020

Result Entity Set

Min_Period

Max_Period

2018

2020

2. In the Advanced section, click Grouping Attributes.

The Group Attributes window appears.

For example: Reducer process configured to produce the Min and Max Start Date grouped by Location.

Previous Step Entity Set

ProjectId

Location

Period

1

NY

1/2018

1

NY

1/2019

1

CA

1/2020

Result Entity Set

Location

Min period

Max period

NY

1/2018

1/2019

CA

1/2020

1/2020