This recipe demonstrates how to read data from a CSV (Comma Separated Value) file using a text datasource.
- Create a text datasource (saving-chinese.ds).
- Enter the file path of the CSV file into the “Define Text Datasource > File URL” field.
- Set Date, Time and Timestamp formats properly. Set “Access Type” to “Separator Character”. Select the “First line is header” checkbox.
- On the next page, select “Separator” as “Comma”. Infer schema to load data. Click “Finish”.
To download the necessary files for this recipe, refer to the attached ZIP package.