Examples

Pentaho Data Integration
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
Perform the following steps to demonstrate a simple example of the Row Normaliser step:
  1. Create the following sample table of product sales data as an input source:
    Date PR1_NR PR1_SL PR2_NR PR2_SL PR3_NR PR3_SL
    January 5 100 10 250 4 150
  2. Input the values shown in the following graphic in the Row Normaliser step:

    Row normaliser values example
  3. Run the Row Normaliser step.
The following table will display in the Preview data pane:


Results in the Preview data pane

The design-tools/data-integration/samples/transformations directory contains the following example KTRs that show how to use this step:

Example KTR File Description
Row Normaliser - Simple example.ktr Shows a simple example of normalizing sales data.
Row Normaliser - turn a single row into 3 rows.ktr Shows an example of splitting fields into columns then normalizing the columns.