AO Business Keyword Parser

Advanced Object (AO) Business Keyword Parser takes a business name as input and uses a user-defined table of values to generate two separate fields for matching purposes. There are two inputs: the data input stream, and the look-up table used for parsing and standardization (K input). The macro produces a single output containing two fields:

Business_Main is the significant part of Firm Name (for example, National Insurance Company of Ohio).

Business_Keyword is the qualifying part of Firm Name (for example, National Insurance Company of Ohio).

See the Repository Samples folder for an example of AO Business Keyword Parser in use.

AO Business Keyword Parser configuration parameters

AO Business Keyword Parser has a single set of configuration parameters in addition to the standard execution options:

Input

Business

Field containing business name. Required. Default: None.

Key/Split lookup table

The keyword table should be in TXT or CSV format and contain up to three columns: Value, Category, and (optionally) user-defined Standard.

Value	User-defined values to be used in parsing. Required. Default: None.
Category	Indicates whether Values are KEY or SPLIT. Values such as at, of, and in are good examples of SPLIT. Values such as NJ, NY, and Colorado are good examples of type KEY. Used to separate `Business_Main` from `Business_Keyword` on output based on user-defined keywords. Required. Default: None.
Standard	Used to standardize selected Values on output. Examples: OH to Ohio, NM to New Mexico, Cndn to Canadian. Optional. Default: None.

Configure AO Business Keyword Parser

Connect the AO Business Keyword Parser macro to two inputs: the data input stream and the user-defined table for parsing and standardization (K input).
Select AO Business Keyword Parser, and then go to the Configuration tab on the Properties pane.
Select Business and select the field containing the business name.
Select Value and select the field containing the values to be used in parsing.
Select Category and select the field that specifies whether Value is to be applied as KEY or SPLIT during parsing.
Optionally, select Standard and select the field containing the standardized version of Value.
Optionally, select parsing Options:
- Select Detect key after split to recognize unknown key variants that appear after SPLIT.
- Select Standardize all firm words to enable standardization of KEY terms in both Business_Keyword and Business_Main output fields
Optionally, go to the Execution tab, and then set Web service options.