Task 1. Create the Flat File Data Object
In this task, you use the Add Flat File wizard to create a flat file data objects from the LA_Customers data file.
1. In the Projects Navigator, select the Customers folder in your tutorial project.
Note: You must select the project or folder where you want to create the flat file data object before you can create it.
2. Click New > Flat File Data Object.
The Add Flat File wizard appears in the Discovery workspace.
3. Select Browse and Upload , and click Choose File.
4. Browse to the location of LA_Customers.csv, and click Open.
5. Click Next.
The Choose type of import page displays Delimited and Fixed-width options. The default option is Delimited.
6. Click Next.
7. Under Specify the delimiters and text qualifiers used in the data, select Double quotes as a text qualifier.
8. Under Specify lines to import, select Import from first line to import column names from the first line that is not empty.
9. Click Next.
The Column Attributes section shows the name, datatype, precision, scale, and format for each column.
10. Click Next.
The Name field displays LA_Customers.
11. Optionally, change the name of the file and add a description.
12. In the Folders section, select the Customers folder.
13. Click Finish.
The LA_Customers data object appears in the Discovery workspace with the data preview of the source data.