Create a Reference Table From a Flat File
You can import reference data from a CSV file. Use the New Reference Table wizard to import the file data.
You must configure the properties for each flat file that you use to create a reference table.
Analyst Tool Flat File Properties
When you import a flat file as a reference table, you must configure the properties for each column in the file. The options that you configure determine how the Analyst tool reads the data from the file.
The following table describes the properties you can configure when you import file data for a reference table:
Properties | Description |
|---|
Delimiters | Character used to separate columns of data. Use the Other field to enter a different delimiter. Delimiters must be printable characters and must be different from the escape character and the quote character if selected. You cannot select non-printing multibyte characters as delimiters. |
Text Qualifier | Quote character that defines the boundaries of text strings. Choose No Quote, Single Quote, or Double Quotes. If you select a quote character, the wizard ignores delimiters within pairs of quotes. |
Column Names | Imports column names from the first line. Select this option if column names appear in the first row. The wizard uses data in the first row in the preview for column names. Default is not enabled. |
Values | Option to start value import from a line. Indicates the row number in the preview at which the wizard starts reading when it imports the file. |
Creating a Reference Table from a Flat File
When you create a reference table data from a flat file, the table uses the column structure of the file and imports the file data.
1. Click New > Reference Table.
The New Reference Table Wizard appears.
2. Select the option to Import a flat file.
3. Click Next.
4. Click Choose File to select the flat file.
5. Select a code page that matches the data in the flat file.
6. Click Upload to upload the file data.
7. Click Next.
8. Configure the flat file properties.
The properties identify the delimiter that the file uses and whether the first line of the file contains column names.
9. To preview the properties that you configured, refresh the Preview pane.
10. Click Next.
11. Configure the properties for each column.
The properties include the column name, data type, precision, and scale.
If the column contains data that a transformation can return in a reference data search, select the Valid option.
12. Optionally, add a column to include low-level descriptions as metadata in the reference table.
13. Optionally, enter an audit note for the table.
The audit note appears in the audit trail log.
14. Click Next.
15. Enter a name for the reference table, and select a location for the reference table object in the Model repository.
16. Optionally, enter a description of the table.
17. Click Finish.