Using Advanced Import - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
Overview
Reference
Tips
How Do I
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

The Advanced Import function allows you to selectively import data into lookup tables used by Advanced Transformer, Table Lookup, and Open Parser. Use Advanced Import to:

  • Extract terms from a selected column in a delimited, user-defined file.
  • Extract single-word terms (tokens) from a selected column in a delimited user-defined file. When you extract tokens, you can identify the number of times that the terms occurs for a given column in the file and create groupings for related terms and add them to the table.

The file that contains the data you want to import must meet these requirements:

  • Must be UTF-8 encoded.
  • Must be a delimited file. Supported delimiter characters are comma (,), semicolon (;), pipe (|), and tab (\t).
  • Fields with embedded delimiters must be start and end with double quotes, for example "1,a","2,b","3,c".
  • A literal quote in a field starting and ending with double quote must have two quotes, for example "2"" feet".
  1. In Enterprise Designer, select Tools > Table Management.
  2. Select the table into which you want to import data.
  3. Click Adv Import.
  4. Click Browse and select the file that you want to import.
  5. Click Open.
  6. Select a table column from the Column list. The sample data shows the frequency of occurrence for each term listed in the user-defined table. Frequency is only displayed for terms that are not yet in the existing table.
  7. To view terms as single words, select Separate into single-word terms.
  8. For Advanced Transformer and Open Parser tables:
    1. Select a term from the list on the left.
    2. Click the right arrow to add the term to the list on the right. Click the left arrow to delete a selected term from the table list.
    3. Click OK to save the changes to the table.
  9. For Table Lookup tables:
    1. Click Add table grouping button to add a table grouping.
    2. Click New.
    3. Type a new term and then click Add. Continue adding terms until finished and then click Close.
    4. Select a term from the list and then click Add. Continue adding terms until finished and then click Close. The new terms are added to the terms list on the right.
    5. Select a term on the left and then click the right arrow to add the term to the selected grouping. Click the left arrow to delete a term from one of the groupings.
    6. To modify a term, select it from the list on the right and then click Modify term button.
    7. To delete a term, select it from the list on the right and then click Delete term button.
    8. Click OK to save the changes to the table.