Data Profiling

Back Next

Exporting column values to a dictionary

You can export one or more value frequencies of a column to a dictionary. To export the value frequencies of different columns, you need to design the dictionary with the required columns, and then export the values one at a time. Before you export the value frequencies to a dictionary, verify that you have enabled the dictionary permissions and privileges for the user role in

Administrator

From the summary view of the profile results section, select a column that you want to export to a dictionary.

Click the column name.

The column appears in the detailed view.

Optionally, if you want to export specific value frequencies, select the values from the value distribution table. By default,

Data Profiling

exports all the value frequencies.

In the detailed view section, click the export values to a dictionary icon

The

Export Values to a Dictionary

window appears.

Specify the following dictionary details:

Export Mode. You can create a new dictionary, or you add to an existing dictionary. By default the

Create a dictionary

option is selected.

Name. Enter a name for the dictionary.

Description. Optionally, enter a description.

Location. Click

Browse

and then select a project or folder where you want to save the dictionary.

If you choose the

Add to an existing dictionary

option, specify the following details:

Dictionary. Click

, and then select an existing dictionary from the

Select Dictionary

window.

Before you select an existing dictionary, verify that you have the required permissions for the specific dictionary.

Add to Column. Select the column to which you want to export the value frequencies in the dictionary.

Select the value range. You can choose to export

All

Selected

Unique

, or

Non-unique

value frequencies depending upon the values you selected in the value distribution table.

Click

Export

Data Profiling

exports the value frequencies to the dictionary in Data Quality. To view the exported values in the dictionary, click the notifications link that appears after you export.

Rename Saved Search

Table of Contents

Data Profiling

Data Profiling

Exporting column values to a dictionary

Exporting column values to a dictionary