Skip to main content Skip to complementary content

Denormalizing on one column


  1. Drop the following components: tFileInputDelimited, tDenormalize, tLogRow from the Palette to the design workspace.
  2. Connect the components using Row main connections.
  3. On the tFileInputDelimited Component view, set the filepath to the file to be denormalized.
  4. Define the Header, Row Separator and Field Separator parameters.
  5. The input file schema is made of two columns, Parents and Children.
  6. In the Basic settings of tDenormalize, define the column that contains multiple values to be grouped.
  7. In this example, the column to denormalize is Children.
  8. Set the Delimiter to separate the grouped values.
  9. Select the Merge same value check box, if you know that some values to be grouped are strictly identical.
  10. Save your Job and press F6 to execute it.


All values from the column Children are grouped by their Parents column.

|Parents|Children     |
|Kate   |Jack;Caroline|
|Chris  |Liz          |
|Peter  |John;Michael |

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!