Column Mapping - Report Mining - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

Report Mining

Platform
OnBase
Product
Report Mining
Release
Foundation 22.1
License
Standard
Essential
Premier

Column mapping defines how columns are populated in the output file.

Note:

Before mapping columns, be sure you've read and understood the Important Concepts for Area Configuration and Mapping.

The procedure for mapping columns depends on the type of information that a column contains, also called the data type. Descriptions of each data type are provided in the following table.

Data Type

Description

Static Text

Static text is a specific word or phrase that is displayed for every record pulled from the selected Document Type.

For example, if multiple Document Types are assigned to a process, the static text column can be used to identify the Document Type that a record came from.

Keyword

Keyword columns display a Keyword Value from the document containing the record. They can also contain the document's Document Date or Date Stored.

Page Data

Page data is a value that occurs on a specific line of each page and occurs only once per page. For example, this may be a report title or a page number.

Record Group Single Data

Single data is information that occurs only once within a record group and applies to every record in the record group. For example, this may be the name of a company or customer.

Record Primary Data

You must map one column (and only one column) as primary data.

Primary data is key information that is available for each record in a record group. For each piece of primary data found in a document, a new row is generated in the output file.

For example, each record in a document may contain a customer's account number.

Record Secondary Data

Secondary data is additional information about a record that occurs on the same line as the primary data.

Tip:

For an illustrated example of record group data types, see Definitions.

To begin mapping columns, proceed to Accessing Column Mapping.