The Row Normaliser step takes a pivoted dataset and normalizes the data. In simple words, it converts columns to rows. In order to explain how to use and configure the step, we will normalize the data shown earlier. Our purpose, in this case, will be to have something like this:
Product sales normalized
First of all, let's prepare the source data:
- Create a Transformation and use a Data Grid to enter the data as shown in the example.
You can save time by downloading the sample Transformation from the book's site.
- Run a preview to make sure the input is well configured.
Taking into account ...
