Icon

Bank Customer Name Validation with Single-Field Indexer

<p>This workflow demonstrates how <strong>M|Box's Single-Field Indexer and Approximate Index Matcher</strong> nodes can be combined to efficiently and reliably <strong>index and search customer name</strong> data.</p><p>Workflow Overview:</p><ol><li><p>The workflow loads:</p><ul><li><p>A reference table containing full customer names and IBANs.</p></li><li><p>A search table including a misspelled name to search for.</p></li></ul></li><li><p>The <strong>Single-Field Indexer</strong> constructs a fast, fault-tolerant search index from the customer names.</p></li><li><p>The <strong>Approximate Index Matcher</strong> searches the index for the search term and gives you the closest match.</p></li><li><p>The search result is joined with the original table to get the full customer name and IBAN</p></li></ol><p>Index-based matching with the <strong>M|Box Single-Field Indexing and Matching nodes</strong> ensures robust and scalable name search, even in the presence of incorrect, fuzzy inputs or spelling errors. This makes it ideal for:</p><ul><li><p>Matching user-entered or third-party data against a standardized reference set</p></li><li><p>Improving search and matching quality without sacrificing performance or explainability</p></li></ul>

URL: exorbyte/KNIME https://exorbyte.ai/knime
URL: exorbyte GmbH https://exorbyte.ai/

Request/Activate Exorbyte License

Request and register your exorbyte license before running any M|Box nodes.

If you do not have an active license, within the License Requester:

  1. Choose Demo (30 days) or Production.

  2. Enter your email (and Customer Token if production).

  3. Execute the node – it sends a secure request to the exorbyte team.

  4. When you receive the .lic file, reopen the node → Use available license fileand run the node

Afterwards, or if you already have an active license, run License Activator

⚠️ Each KNIME installation or Hub environment needs its own license

👉 See full exorbyte License Activation Guide

Import Data

Import two data tables:

  • Reference table: A table containing the customers' full, correct names and IBANs

  • Search table: A table with the search term(s) to query the index

Indexing & Matching

  • Use the Single-Field Indexer to create an index out of the customer names

  • Retrieve the customer name you want to search for with the Approximate Index Matcher. This node searches the index and quickly finds the best match, even in the presence of incorrect or incomplete inputs

Results

Extract the name match from the Approximate Index Matcher and join with the original data to get the full row with the customer's IBAN.

Activate yourexorbyte license
License Activator (Labs)
Extract thematched name
Ungroup
Join with customer datato retrieve the correct row
Joiner
Search term
Table Creator
Search the index
Approximate Index Matcher (Labs)
Importcustomer data
CSV Reader
Index thecustomer names
Single-Field Indexer (Labs)
License Requester (Labs)

Nodes

Extensions

Links