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 Profile Column Data

You can create a reference table from one or more values in a profile data column. Select a column in a profile, and select the column values to add to the reference table.

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 column to add to a reference table.

The profile overview lists the profile column names.

Review the column data.

To view the column data, click the column name.

In the detailed profile view, select the data values to add to the reference table. You can select values one by one, or you can select all.

Right-click the column name and select

Add to Reference Table

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

Find the column data in the Values panel in the center 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 Profile Column Data

Creating a Reference Table from Profile Column Data