Reference Data Guide

Back Next

Creating a Reference Table from a Flat File

You can create a reference table from data stored in a flat file.

Select

File

New

Reference Table

from the Developer tool menu.

In the new table wizard, select

Reference Table from a Flat File

Browse to the file you want to use as the data source for the table.

Enter a name for the table.

Select a project to store the table metadata.

At the Location field, click

Browse

. The

Select Location

dialog box opens and displays the projects in the repository. Select the project you need.

Click

Set UTF-8 as the code page.

Specify the delimiter that the flat file uses.

If the flat file contains column names, select the option to import column names from the first line of the file.

The following table describes optional table properties:

Property	Default Value
Text qualifier	No quotation marks
Start import at line	Line 1
Row Delimiter	\012 LF (\n)
Treat consecutive delimiters as one	Cleared
Escape character	Empty
Retain escape character in data	Cleared
Maximum rows to preview	500

Click

Next.

Select the column that contains the valid values.

The following table describes optional properties:

Property	Default Value
Include a column for row-level descriptions	Cleared
Audit note	Empty
Default value	Empty
Maximum rows to preview	500

Click

Finish.

The reference table opens in the Developer tool workspace.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.