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.

Procedure

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

Fields marked with a * are mandatory.
In the Property Type list, select Built-in.
In the File name/Stream field, enter the path to the file containing the input data on which you want to apply the preparation.
Define the characters to be used as Row Separator and Field Separator.
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.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!