Skip to end of metadata Description The Row Normaliser step normalizes data back from pivoted tables. For example, below is a sample table of product sales data: Month Product A Product B Product C 2003/01 10 5 17 2003/02 12 7 19 ... ... ... ... The Row Normaliser step converts the data into the format below so that it is easier to update your fact table: Month Product sales 2003/01 A 10 2003/01 B 5 2003/01 C 17 2003/02 A 12 2003/02 B 7 2003/02 C 19 ... ... ... Options The following options are available for the Row Normaliser Step: Option Description Step name Name of the step; this name has to be unique in a single transformation. Typefield The name of the type field (product in the example above) Fields table A list of the fields you want to normalize; you must set the following properties for each selected field: Fieldname: Name of the fields to normalize (Product A ? C in the example). Type: Give a string to classify the field (A, B or C in our example). New fiel...