August 15, 2023

Denormalizing on one column – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Denormalizing on one column – Docs for ESB 6.x

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.

    Use_Case_tDenormalizePerl2.png

  4. Define the Header,
    Row Separator and Field Separator parameters.
  5. The input file schema is made of two columns, Fathers and Children.

    Use_Case_tDenormalizePerl3.png

  6. In the Basic settings of
    tDenormalize, define the column that
    contains multiple values to be grouped.
  7. In this use case, the column to denormalize is Children.

    Use_Case_tDenormalizePerl4.png

  8. Set the Delimiter to
    separate the grouped values. Beware as only one column can be
    denormalized.
  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.
Use_Case_tDenormalizePerl5.png

All values from the column Children (set as
column to denormalize) are grouped by their Fathers column.
Values are separated by a comma.

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x