Task 1. Create the Customers Flat File Data Object
In this task, you use the Add Flat File wizard to create a flat file data object from Customers.csv.
1. On the New header, click Flat File Data Object.
The Add Flat File wizard appears.
2. Select Browse and Upload, and click Choose File to browse to the location of Customers.csv.
3. Accept the default Delimited option.
4. Click Next.
5. Under Specify lines to import, select Import from first line to import column names from the first non-blank line.
6. Click Show.
The details panel updates to show the column headings from the first row.
7. Click Next.
The Column Attributes panel shows the datatype, precision, scale, and format for each column.
8. Edit the following column attributes:
Column Name | Datatype | Precision | Scale |
---|
CHECKING_BALANCE | Number | 38 | 0 |
SAVINGS_BALANCE | Number | 38 | 0 |
9. Click Next.
10. Select the Customers folder in the Folders panel where you want to add the flat file.
The Flat Files panel displays the flat files that exist in a project or folder.
11. Click Finish.
The Analyst tool displays the data preview for the Customers flat file data object on the Data Preview tab. View the properties for the flat file on the Properties tab.