August 15, 2023

Configuring the input data and the structure mappings – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the input data and the structure mappings – Docs for ESB 6.x

Configuring the input data and the structure mappings

  1. Double-click the tFileInputDelimited
    component to open its Basic settings
    view.

    components-trestclient_s2-3.png

  2. Specify the input file in the File name
    field, fill the Header field with 1 to skip
    the header row, and keep the rest parameters as they are.
  3. Click the […] button next to Edit schema to open the [Schema] dialog box, and edit the input schema as
    follows:

    • id, type Integer, 2 characters
      long, set as the key column

    • first_name, type String

    • last_name, type String

    components-trestclient_s2-4.png

  4. Double-click the tXMLMap component to
    open the Map Editor.
  5. Rename the root node in the output
    table: right-click the node, select Rename
    from the contextual menu, and specify a new name in the pop-up dialog box,
    user in this example.
  6. Select all the three columns in the input table and drop them onto the
    user node, and select the Create as sub-element of target node option from
    the pop-up dialog box to set these columns as sub-elements of the user node. When done, click OK to validate the mappings and close the Map
    Editor.

    components-trestclient_s2-5.png

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