Creating Word Definition Tables
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.
► 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. |
► 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. |
|
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. |
► 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. |
► To sort word definitions
Click the Word/Phrase column header to sort in ascending and descending order.
► 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. |
► 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. |
Related Topics