on 04-24-2018 9:41 PM
There is a currently a script written in Perl which which performs address matching from two different HANA tables. It first reads one table and then loops through all the records to perform a SELECT query with a CONTAINS clause to perform a fuzzy search on multiple columns. It works great but I do suspect there might be a SQL only approach that could work just as well and scale even better. The CONTAINS function does not allow multiple table columns to be referenced so a JOIN with a CONTAINS will not work. What would be a suggested SQL only approach to doing address matching in 2 HANA tables? Loops? An example would help.
Here are the example tables:
TABLE ONE columns ID_ONE, STREET_NUMBER, STREET_NAME, ZIP_CODE
TABLE TWO columns ID_TWO, STREET_NUMBER, STREET_NAME, ZIP_CODE
MATCHED RESULTS TABLE columns ID_ONE, ID_TWO, FUZZY_SCORE
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.