August 15, 2023

Configuring the source Excel input – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the source Excel input – Docs for ESB 6.x

Configuring the source Excel input

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

    use_case_tsalesforceoutput_10.png

  2. In the File name/Stream field, browse to or
    enter the path to the Excel file that contains the Account ID data to be
    inserted. In this example, it is D:/AccountIdInput.xls. And the content of the file is as
    follows:

    use_case_tsalesforceoutput_11.png

  3. Select the All sheets check box to retrieve
    the data of the entire Excel file.
  4. In the Header field, enter 1 to skip one row in the beginning of the
    file.
  5. Click the […] button next to Edit schema and in the pop-up schema dialog box,
    define the schema by adding three columns AccountId, LastName and
    Name of String type.

    use_case_tsalesforceoutput_12.png

    Click OK to save the settings and close the
    dialog box.
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