[Text DataSources] CSV

Reporting Design Cookbook Data Design
1

This recipe demonstrates how to read data from a CSV (Comma Separated Value) file using a text datasource.

Steps taken:

  1. Create a text datasource (saving-chinese.ds).
  2. Enter the file path of the CSV file into the “Define Text Datasource > File URL” field.
  3. Set Date, Time and Timestamp formats properly. Set “Access Type” to “Separator Character”. Select the “First line is header” checkbox.
  4. 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.
CSV.zip