Reference Data Guide

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.1
- 10.5
- 10.4.1
- 10.2.2

Back Next

Reference Table Updates

The business data that a reference table contains can change over time. Review and update the data and metadata in a reference table to verify that the table contains accurate information. You update reference tables in the Analyst tool. You can update the data and metadata in a managed reference table and an unmanaged reference table.

You can perform the following operations on reference table data and metadata:

Manage columns: You can add columns, delete columns, and edit column properties.
Manage rows: You can add rows of data to a reference table.
Edit reference data values: You can edit a reference data value.
Replace data values: Use the
Find and Replace
option to replace data values that are no longer accurate or relevant to the organization. You can find a value in a column and replace it with another value. You can replace all values in a column with a single value.
Export a reference table: Export a reference table to a comma-separated values (CSV) file, dictionary file, or Excel file.
Enable or disable edits on an unmanaged table: Update an unmanaged reference table to enable or disable edits to table data and metadata.
Refresh the reference table data: Reload the reference table data to the Analyst tool to view the latest changes to the data.