New reply on DataCleaner's online discussion forum (http://datacleaner.org/forum):
drexler replied to subject 'Fuzzy Matching with two tables' ------------------- Hi Ricardo, Like Kasper mentioned, there is no direct way to do this. But I can point out one possibility, in the hope it is of use to you. If the "perfect" and "dirty" tables share a common format, you can create a third "combined" table that contains records of both. You have to also add a "source_indicator" column that tells if the record was from the "perfect" or the "dirty" table. After that you can find matches in that combined table. You will need to use the training tool to create a matching model. In the training tool you can define a fixed rule, stating that records having the same value in the "source_indicator" column are never a match. That way you will find all records of "dirty" that match record(s) in "perfect". regards, Hans Drexler ------------------- View the topic online to reply - go to http://datacleaner.org/topic/1031/Fuzzy-Matching-with-two-tables -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
