Memory Group by

Owned by Former user (Deleted)
Last updated: Aug 13, 2021 by Virginia Agnew

(warning) PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit the Pentaho Enterprise Edition documentation site.

Description

This step builds aggregates in a group by fashion and does not require a sorted input since it processes all rows within memory. When the number of rows is too large to fit into memory, you need to use the combination of the Sort rows and Group by steps.

Options

Option

Definition

Step name

The name of this step as it appears in the transformation workspace.

Always give back a result row

If you enable this option, the Group By step will always give back a result row, even if there is no input row. 
This can be useful if you want to count the number of rows.  Without this option you would never get a count of zero (0).

The field that make up the group

After retrieving fields using the Get Fields button, designate the fields to include in the group. See the Group be step for more details.

Aggregates

After retrieving fields using the Get lookup fields button, designate the fields to include in the group. See the Group be step for more details.

Metadata Injection Support (7.x and later)

All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.