Data Quality Getting Started Guide

10.5
- 10.5.6
- 10.4.0

Back Next

Task 1. Create a Reference Table

In this task, you will create the Reftab_CustomerTier_Codes reference table to standardize the valid values for the customer tier data.

Click

New

Reference Table

The

New Reference Table

wizard appears.

Select

Use the reference table editor

Click

For each column you want to include in the reference table, click the

Add New Column

icon and configure the column properties for each column.

Add the following column names: CustomerID, CustomerTier, and Status. You can reorder the columns or delete columns.

Enter an optional description and set the default value to

The Analyst tool uses the default value for any table record that does not contain a value.

Click

In the

Name

field, enter

Reftab_CustomerTier_Codes

In the

Folders

section, select the

Customers

folder in the tutorial project.

Click

Finish

The reference table appears in the

Design

workspace.

From the

Actions

menu, select

Add Row

to populate each reference table column with the following four values:

CustomerID = LA1, LA2, LA3, LA4

CustomerTier = 1, 2, 3, 4.

Status= Active, Inactive

Lesson 8. Creating Reference Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

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

Rename Saved Search

Table of Contents

Data Quality Getting Started Guide

Data Quality Getting Started Guide

Task 1. Create a Reference Table

Task 1. Create a Reference Table