August 16, 2023

Preparing the source data – Docs for ESB 6.x

Preparing the source data

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

    components-texabulkexec_s1_tfixedflowinput.png

  2. Click the […] button next to Edit schema to open the [Schema] dialog box.

    components-texabulkexec_s1_tfixedflowinput_schema.png

  3. Click the [+] button to add six columns:
    EmployeeID of the Integer type, EmployeeName,
    OrgTeam and JobTitle of the String type,
    OnboardDate of the Data type with the yyyy-MM-dd
    date pattern, and MonthSalary of the
    Double type.
  4. Click OK to close the dialog box and accept
    schema propagation to the next component.
  5. In the Mode area, select Use Inline Content (delimited file) and enter the
    following employee data in the Content
    field.

  6. Double-click the tFileOutputDelimited
    component to open its Basic settings
    view.

    components-texabulkexec_s1_tfileoutputdelimited.png

  7. In the File Name field, specify the file into
    which the input data will be written. In this example, it is “E:/employee.csv”.
  8. Click Advanced settings to open the Advanced settings view of the tFileOutputDelimited component.

    components-texabulkexec_s1_tfileoutputdelimited_advanced.png

  9. Select the Advanced separator (for numbers)
    check box and in the Thousands separator and
    Decimal separator fields displayed, specify
    the separators for thousands and decimal. In this example, the default values
    “,” and “.” are used.

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