Examples

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.