August 16, 2023

Scenario 2: Denormalizing on multiple columns – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Scenario 2: Denormalizing on multiple columns – Docs for ESB 6.x

Scenario 2: Denormalizing on multiple columns

  1. Drop the following components: tFileInputDelimited, tDenormalize, tLogRow
    from the Palette to the design
    workspace.
  2. Connect all components using a Row
    main     connection.
  3. On the tFileInputDelimited
    Basic settings panel, set the filepath to
    the file to be denormalized.

    Use_Case_tDenormalizeJava2.png

  4. Define the Row and
    Field
    separators, the Header and other information if required.
  5. The file schema is made of four columns including: Name, FirstName, HomeTown,
    WorkTown.

    Use_Case_tDenormalizeJava3.png

  6. In the tDenormalize
    component Basic settings, select the
    columns that contain the repetition. These are the column which are meant to
    occur multiple times in the document. In this use case, FirstName, HomeCity and WorkCity are the columns against which the denormalization is
    performed.
  7. Add as many line to the table as you need using the plus
    button. Then select the relevant columns in the drop-down list.

    Use_Case_tDenormalizeJava4.png

  8. In the Delimiter column,
    define the separator between double quotes, to split concanated values. For FirstName column, type in “#”, for HomeCity, type in “§”, ans for WorkCity, type in
    “¤”.
  9. Save your Job and press F6 to execute it.

    Use_Case_tDenormalizeJava5.png

    The result shows the denormalized values concatenated using a
    comma.
  10. Back to the tDenormalize
    components Basic settings, in the To
    denormalize table, select the Merge same
    value     check box to remove the duplicate occurrences.
  11. Save your Job again and press F6 to execute it..
Use_Case_tDenormalizeJava6.png

This time, the console shows the results with no duplicate
instances.

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