Address Matching with Multi-Field Indexer

<p>This use case demonstrates how <strong>M|Box's Multi-Field Indexer and Multi-Field Index Matcher</strong> nodes can be combined to efficiently <strong>index and search multi-field address data</strong>, even with faulty or incomplete inputs.</p><p>Workflow Overview:</p><ol><li><p>The workflow loads</p><ul><li><p>A reference table of full addresses, divided into three address fields.</p></li><li><p>A search table including misspelled search terms for these fields</p></li></ul></li><li><p>The <strong>Multi-Field Indexer</strong> constructs a fast, fault-tolerant search index from all three columns of the reference table.</p></li><li><p>The <strong>Multi-Field Index Matcher</strong> lets you select a column to search the index and quickly, reliably and fault-tolerantly finds a match. The node also gives you the quality of the match and the number of the matched row in the reference table.</p></li><li><p>The search result is joined with the original table using using the row number to get the full, correct address.</p></li></ol><p>Index-based matching with the <strong>M|Box Multi-Field Indexing and Matching nodes</strong> ensures robust and scalable address 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 address data against a standardized reference set</p></li><li><p>Searching addresses with incomplete information (e.g. only a street name)</p></li><li><p>Improving address search and matching quality without sacrificing performance or explainability</p></li></ul><p></p>