Skip to main content

How do Table Locators work?


QAID # 11671 Published 

Question / Problem:

How do Table Locators work?

Answer / Solution:

The Table Locator finds data that appears on a document in the form of a table. One Table Locator can find one table model.

Table models are defined in the project settings. No matter what the actual table in the document looks like, it is always mapped to the current table model.

Most tables are found automatically, especially invoice tables. An invoice table can be found automatically if it has at least three columns: quantity, unit price and total price for an item.

All other tables are either found automatically if keywords are provided for the table header, or they are extracted using a line-by-line pattern specified by the user. The automatic extraction of invoice tables requires a Format Locator that finds monetary amounts on the entire document. Based on the results from this locator, the Table Locator identifies the line items in the table.

For manual extraction, select one line item in the document and then select all the values that are of interest in that line item.

Table models are defined in the Project Settings dialog box. A table model defines the column structure of a certain type of table. For example, an order table can be defined with columns such as Article Code, Quantity, Discount, and Unit Price. Each table model is a subset of the column pool. Columns can be used in more than one table model, for example the Quantity column would be used in a table model for invoice tables as well as in a model for order tables.

Applies to:

Product Version Category
AXPRO 3.5 Configuration
AXPRO 3.5 Project Builder