Upload a table of valid values

Create the table of values

1. Determine the valid values for the field.
2. Prepare a comma-separated value (.csv) file with a single column and with a column heading in the first row. Enter a single value of u to 100 characters in each subsequent row.

   Note:

   For a field that is the subsidiary field in a linked pair, the table that you upload should contain two columns. The first column should contain the values for that field, and the second column should contain the values that are valid for the controlling, parent field.

   For example:

   Typical format:

   

   Format for subsidiary linked fields only:

   

3. Save the file with the .csv (comma-separated value) file extension.

Upload the table of valid values

1. In the left navigation pane, click the Settings icon ().
2. In the Configure System section, click Manage Topic Workflow Configurations.
3. Click the Row Action menu () for a configuration, and then click Manage Fields.
4. Click the Row Action menu () for a field, and then click Define Values.
5. Click Upload Table.
6. In the File to upload field, enter the full path and file name of the .csv file, or click Browse to locate the file on your computer.
7. Click Upload.
8. If necessary, you can edit the values or change the display order for the values.