Fuzzy match two hash tables?
- by alex
Hi,
I'm looking for ideas on how to best match two hash tables containing string key/value pairs.
Here's the actual problem I'm facing: I have structured data coming in which is imported into the database. I need to UPDATE records which are already in the DB, however, it's possible that ANY value in the source can change, therefore I don't have a reliable ID.
I'm thinking of fuzzy matching two rows, source and DB and make an "educated" guess if it should be updated and inserted.
Any ideas would be greatly appreciated.