You can import dictionary values from a Microsoft Excel file or any file that uses a delimiter that
Data Quality
recognizes. You can import the file data to an empty dictionary or to a dictionary that contains data. When you import the file data,
Data Quality
adds the data to the first empty row in the dictionary.
If you import data from a file with multiple columns, verify that the valid data column in the file matches the valid data column in the dictionary. The first column is the valid value column by default.
From the
Explore
page, select and open a dictionary.
Or, click
New
and create a dictionary.
If you create a dictionary, complete the fields on the Definition tab.
Select the Configuration tab.
Select the option to import data from a file.
In the
Import a flat file
dialog box, complete the following steps:
Choose the file that contains the data to import.
Select or clear the option to import column names. The option is cleared by default.
Select the line in the file from which to begin the data import. By default,
Data Quality
imports data from the first line in the file.
If you import data from a delimited file, select the delimiter. By default,
Data Quality
uses a comma delimiter.
If the file uses single quotes or double quotes as a text qualifier, select the text qualifier. By default,
Data Quality
does not recognize text qualifiers.
A dictionary can contain a maximum of 42 columns. If you try to import a file with additional columns,
Data Quality
prompts you to reduce the number of columns in the file.
Click
Import
.
Data Quality
adds the file contents to the dictionary.
Save the dictionary.
When you import a very large dictionary, Data Quality may save the dictionary when the import operation is complete. A very large dictionary may contain up to 55 MB of data.
ASK INFAPreview
