Transact

⌘K
  1. Home
  2. Transact
  3. Features and Functions
  4. Administrator Role and Fe...
  5. Modules and Plugins
  6. Extraction Module
  7. Fuzzy DB Extraction
  8. How to configure Field Fuzzy with separate index fields pointing to different Database

How to configure Field Fuzzy with separate index fields pointing to different Database

Applies to:
Ephesoft Transact Version

Component:

Field Fuzzy

Issue:
Demonstrate an example on How to configure Field Fuzzy with separate index fields pointing to different Database ?

 

Solution:

That can be done in a same way by creating multiple mappings. Taking your example I have setup a batch class as below:

Screenshot 1: Created a Batch Class with single Document Type and 7 index fields names f1 to f7. In this example I have put KV extraction rules on f1 and f4 index fields

 

 

Screenshot 2: In Field Fuzzy I have created 2 groups. f1 group is having mapping information for fields f1 to f3 and f2 group has mapping for index fields for fields f4 to f7. Both groups are referring to 2 different tables us_invoice and po_configuration respectively.

 

Screenshot 3: This is an example for  mapping

 

 

Screenshot 4: Result are retrieved from 2 different groups. f1 to f3 values are are fetched from table us_invoice on the basis of value extracted in f1 field. f4 to f7 is extracted from po_configuration table on the basis of value extracted by f4 field.