Hello, bubblers! I need help.
I want to check if a data I want to input had already been added or not. So I want to get all matched datas in a repeating group, and let the user check if there are duplicates.
USE CASE:
- I want to find if a “Customer” already has a record before booking the customer to a room. If there are matches, return all matched records (with percentage of similarity) then merge the record with a selected record?
Customer 1:
First Name: John
Last Name: Smith
Birthday: 01/02/2000
Gender: Male
Customer 2:
First Name: John
Last Name: Smith
Birthday: 08/02/1990
Gender: Male
Customer 3:
First Name: John Arnold
Last Name: Smith
Birthday: 01/02/2000
Gender: Male
I want to check if customer 1 already has a duplicate record before booking that customer and return all possibilities.
Return: (2 existing records matched to Customer 1)
Match1: Customer 2 (70% Similarity)
Match2: Customer 3 (80% Similarity)
How can I achieve this? (Including possible typographical errors)