August 15, 2023

Retrieving the data from a CSV file – Docs for ESB 6.x

Retrieving the data from a CSV file

The input data retrieved by the component must have same model as the dataset on
wich the preparation to operationalize was created.

  1. In the design workspace, select the
    tFileInputDelimited component, and click the
    Component tab to define its basic settings.

    Use_Case_tDataprepRun_dynamic_env_5.png

    Fields marked with a * are mandatory.

  2. In the Property Type list, select
    Built-in.
  3. In the File name/Stream field, enter the path to the
    file containing the input data on which you want to apply the preparation.
  4. Define the characters to be used as Row Separator and
    Field Separator.
  5. Cick the Edit schema button to define the columns of the
    source dataset and their data type.

    Make sure that the schema of the tFileInputDelimited
    component matches the schema expected by the
    tDataprepRun component. In other words, the input
    schema must be the same as the dataset upon which the preparation was made
    in the first place.


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