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
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.
- Open the entity you want to use as the input entity for the BDP process.
- Right-click the attribute you want use as the input attribute and select Drill down to Metadata.
- Double-click Phrases.
- 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.
- 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.
- 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.
-
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.
- (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.
- (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."
- (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.
- 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 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
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
- Click the Select check box of the word/phrase you want to modify. To select all words and phrases, click the Select column header.
- Click Edit word definitions. The Edit selected word definitions window opens.
- Make changes and click Save.
Delete word definitions
To delete word definitions
- Click the Select check box of the word/phrase you want to delete. To select all words and phrases, click the Select column header.
- Click Delete word definitions.
- Click Save.