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

Creating a Reference Table from Value Patterns

You can create a reference table from the column patterns in a profile column. The patterns represent the composition of the data values in one or more column fields. Select a column in the profile, and select the patterns to add to the reference table that you create.

Open the

Library

workspace in the Analyst tool.

Select the

Profiles

asset category.

The library displays a list of the profiles in the Model repository.

Open the profile that contains the value patterns to add to the reference table.

The profile overview lists the profile column names.

Select the column that defines the pattern data that you want to add to the reference table.

Review the column data patterns.

To view the column data, click the column name.

In the detailed profile view, select the column patterns that you want to add.

Right-click the patterns that you selected, and select

Add to Reference Table.

The following image shows the data patterns for a column in the detailed profile view:

Find the column data in the Patterns panel to the left of the detailed view.

The number 1 identifies the

Add to Reference Table

option in the image.

The

Add to Reference Table

Wizard opens.

Select the option to

Create a reference table

You can also select an option to add the data to a current reference table.

Click

The column name appears by default as the reference table name. Optionally, update the name.

Optionally, enter a description and default value.

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

Click

Verify the column properties.

Optionally, choose to create a column for low-level descriptive metadata.

Click

Review the reference table name and description.

Optionally, enter an audit note.

Select a Model repository location for the reference table object.

Click

Finish

Create a Reference Table from Profile Data

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

Reference Data Guide

Reference Data Guide

Creating a Reference Table from Value Patterns

Creating a Reference Table from Value Patterns