{"id":31832,"date":"2018-03-29T08:48:11","date_gmt":"2018-03-29T16:48:11","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/2019-1-2\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/"},"modified":"2020-05-19T12:24:12","modified_gmt":"2020-05-19T19:24:12","slug":"how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/","title":{"rendered":"How to configure Field Fuzzy with separate index fields pointing to different Database"},"content":{"rendered":"<p><strong id=\"aui-3-18-0-4_328285\">Applies to:<\/strong><br \/>\nEphesoft Transact Version<\/p>\n<p><strong>Component:<\/strong><\/p>\n<p>Field Fuzzy<\/p>\n<p><strong>Issue:<\/strong><br \/>\nDemonstrate an example on\u00a0How to configure Field Fuzzy with separate index fields pointing to different Database ?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Solution:<\/strong><\/p>\n<p>That can be done in a same way by creating multiple mappings. Taking your example I have setup a batch class as below:<\/p>\n<p><b id=\"aui-3-18-0-4_1021894\">Screenshot 1:<\/b>\u00a0Created 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<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-14734\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2.png\" alt=\"\" width=\"1918\" height=\"370\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2.png 1918w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2-300x58.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2-768x148.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2-1024x198.png 1024w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><b id=\"aui-3-18-0-4_38427\">Screenshot 2<\/b>: 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.<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/2-1.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-14735\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/2-1.png\" alt=\"\" width=\"1920\" height=\"715\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/2-1.png 1920w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/2-1-300x112.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/2-1-768x286.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/2-1-1024x381.png 1024w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>Screenshot 3:<\/b>\u00a0This is an example for \u00a0mapping<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/3-1.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-14736\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/3-1.png\" alt=\"\" width=\"1917\" height=\"890\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/3-1.png 1917w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/3-1-300x139.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/3-1-768x357.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/3-1-1024x475.png 1024w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/4.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-14737\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/4.png\" alt=\"\" width=\"1920\" height=\"893\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/4.png 1920w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/4-300x140.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/4-768x357.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/4-1024x476.png 1024w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span id=\"aui-3-18-0-4_38462\" style=\"color: #2f2f2f;font-family: Arial;font-size: small\"><b id=\"aui-3-18-0-4_38464\">Screenshot 4<\/b>: 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.<\/span><\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/5.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-14738\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/5.png\" alt=\"\" width=\"1920\" height=\"563\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/5.png 1920w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/5-300x88.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/5-768x225.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/5-1024x300.png 1024w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n","protected":false},"featured_media":0,"parent":31830,"menu_order":1,"comment_status":"closed","ping_status":"open","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to configure Field Fuzzy with separate index fields pointing to different Database | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to configure Field Fuzzy with separate index fields pointing to different Database\" \/>\n<meta property=\"og:description\" content=\"Applies to: Ephesoft Transact Version Component: Field Fuzzy Issue: Demonstrate an example on\u00a0How to configure Field Fuzzy with separate index [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-19T19:24:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/\",\"name\":\"How to configure Field Fuzzy with separate index fields pointing to different Database | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2018-03-29T16:48:11+00:00\",\"dateModified\":\"2020-05-19T19:24:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Features and Functions\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Administrator Role and Features\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Modules and Plugins\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Extraction Module\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Fuzzy DB Extraction\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/\"},{\"@type\":\"ListItem\",\"position\":8,\"name\":\"How to configure Field Fuzzy with separate index fields pointing to different Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to configure Field Fuzzy with separate index fields pointing to different Database | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"How to configure Field Fuzzy with separate index fields pointing to different Database","og_description":"Applies to: Ephesoft Transact Version Component: Field Fuzzy Issue: Demonstrate an example on\u00a0How to configure Field Fuzzy with separate index [&hellip;]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/","og_site_name":"Ephesoft Docs","article_modified_time":"2020-05-19T19:24:12+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/03\/1-2.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/","name":"How to configure Field Fuzzy with separate index fields pointing to different Database | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2018-03-29T16:48:11+00:00","dateModified":"2020-05-19T19:24:12+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Features and Functions","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/"},{"@type":"ListItem","position":4,"name":"Administrator Role and Features","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/"},{"@type":"ListItem","position":5,"name":"Modules and Plugins","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/"},{"@type":"ListItem","position":6,"name":"Extraction Module","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/"},{"@type":"ListItem","position":7,"name":"Fuzzy DB Extraction","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/"},{"@type":"ListItem","position":8,"name":"How to configure Field Fuzzy with separate index fields pointing to different Database"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31832"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=31832"}],"version-history":[{"count":0,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31832\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31830"}],"next":[{"title":"Automatic FuzzyDB Learning","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/automatic-fuzzydb-learning\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31835"}],"prev":[{"title":"How to Perform Multiple FuzzyDB Lookups","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31831"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=31832"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=31832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}