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

User-Defined Reference Data

You can use the values in a data object to create a reference data object.

For example, you can select a data object or profile column that contains values that are specific to a project or organization. Create custom reference data objects from the column values.

You can build a reference data object from a data column to verify the following:

The data rows in the column contain the same type of information.

A source value is valid. The reference object might contains a list of the valid values, or the reference object might contain a list of values that are not valid.

The following table lists common examples of project data columns that can contain reference data:

Information	Reference Data Example
Stock Keeping Unit (SKU) codes	Use an SKU column to create a reference table of valid SKU code for an organization. Use the reference table to find correct or incorrect SKU codes in a data set.
Employee codes	Use an employee code or employee ID column to create a reference table of valid employee codes. Use the reference table to find errors in employee data.
Customer account numbers	Run a profile on a customer account column to identify account number patterns. Use the profile to create a token set of incorrect data patterns. Use the token set to find account numbers that do not conform to the correct account number structure.
Customer names	When a customer name column contains first, middle, and last names, you can create a probabilistic model that defines the expected structure of the strings in the column. Use the probabilistic model to find data strings that do not belong in the column.

Rename Saved Search

Table of Contents

Reference Data Guide

Reference Data Guide

User-Defined Reference Data

User-Defined Reference Data