Creating Word Definition Tables - trillium_discovery - trillium_quality - 17.2

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:56:48.630530

There are multiple ways to access to a word definition table during profiling activities.

  • Attribute's List View of phrases. Right-click the phrase and select Add to word definitions table.
  • Attribute's List View of values. Right-click the value and select Add to word definitions table.
  • Value's Details View. Right-click the value and select Show wide value, and then select Open Word Table. See Adding Word Definitions from Wide Values for details.  

Add a new word definition table

To add a new word definition table

  1. On the Discover bar, select the Library tab.
  2. Right-click the Word Definitions folder and select Add word definitions table. The Word Definitions Table window opens.
  3. Enter a Name for the new table and click OK. A blank word definition table will be created.
    Note: You can also create a new table from within the Manage Word Definitions window before adding word definitions.

Add word definitions to the table

To add word definitions to the table

This procedure illustrates a method for adding word definitions to the table from the List view of phrases.

  1. Open the entity you want to use as the input entity for the BDP process.
  2. Right-click the attribute you want use as the input attribute and select Drill down to Metadata.
  3. Double-click Phrases.
  4. Select the phrase, right-click and select Add to word definitions table. The Manage Word Definitions window opens and selected phrases are displayed in the Word/Phrase column.
  5. To select the existing table, check Existing Table and select the table name from the list. To create a new table, check New Table and enter a table name.
  6. For Category, assign each word and phrase to a category. To create a new category, select Manage categories and follow the procedure in Creating and Managing Categories.
  7. To define a position for the word/phrase, do one of the following in the Position column:
    • If the physical location of the word/phrase is irrelevant, accept the position of DEF (default) .
    • If the definition only applies to the word/phrase when it occurs at the beginning or end of the input attribute, select from the drop-down list either BEG or END.
  8. (Optional) For Recode, enter the recode words and phrases to conform and standardize the data; for example, if you have numbers representing colors in your product color, recode them as words.
  9. (Optional) For Classification, add classifications to a word or phrase to enhance the definition; for example, if you are parsing clothing product data, the word "Sweatshirt" can be added to the "Product" category and then assigned a classification of "Casual."
  10. (Optional) To create synonyms of original values to correct misspellings, click Manage synonyms, and follow the procedure in Managing Synonyms. For more information about using synonyms in the parser, see Synonyms.
  11. Click Save to save the definition to the table and close the Manage Word Definitions window. The word definition table will be saved in the Library in Discovery.
  12. To use the word definition table in the BDP process, you need to import the table from the Library. See Importing an Ignore Word Table and Word Definition Table.

Search word definitions

To search word definitions

  1. Enter the string to search in the Search Words field and press Enter. The list will be updated to display only those word/phrase with the matching name.
    Note: Search strings are not case sensitive.
  2. To search substring, select the Use Substring check box. The substring search will look for word/phrase that contain a specified string anywhere in the word/phrase.
  3. To clear the search click Clear.

Sort word definitions

To sort word definitions

Click the Word/Phrase column header to sort in ascending and descending order.

Edit multiple word definitions

To edit multiple word definitions

  1. Click the Select check box of the word/phrase you want to modify. To select all words and phrases, click the Select column header.
  2. Click Edit word definitions. The Edit selected word definitions window opens.
  3. Make changes and click Save.

Delete word definitions

To delete word definitions

  1. Click the Select check box of the word/phrase you want to delete. To select all words and phrases, click the Select column header.
  2. Click Delete word definitions.
  3. Click Save.