Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation

Modify values from grouped rows


Use the Modify values from grouped rows step to build complex hierarchical data and to group data based on a field. This step modifies hierarchical data to form nested JSON key-value pairs. The step takes non-hierarchical data and changes it to hierarchical data and sends it to other steps.


  • Step name: Specifies the unique name of the Modify values from grouped rows step on the canvas. You can customize the name or leave it as the default.

Grouping fields

Modify values from grouped rows step dialog box
Field Description
Field name Specifies the field name that will be used to group the incoming data.
Pass Through? Select to add the the specified incoming field to the output fields.

In the Target hierarchical field, you can specify a new field name to be added into output or select an incoming hierarchical field name to modify.


Field Description
Hierarchical path Specifies the path that has to be modified or created inside the target hierarchical field.
Action Specifies the action to perform on the target field name.
Value field name Specifies the field for performing the previous action.



The sample transformation Modify_From_Grouped_Rows.ktr demonstrates the capabilities of this step and is available in the plugin distribution package in the data-integration/plugins/hierarchical-datatype-plugin/samples/transformations directory. The use of this step is also demonstrated in the Advanced_Using_Multiples_To Join_And_Edit.ktr transformation. Comments in the transformation explain how the steps are used.

Modify values from group rows example ktr