With this program you will be able to perform most of the necessary actions to clean a database and join two tables from different sources, also FuzzyCruce includes the subset filter, a new similarity measure, in which it is scaled by the shortest word in the comparison.
Run the program and then click on the Load File button and choose the database where is your table.The program will show the path of the file, the existing tables and fields. You can view the contents of each table by clicking the Display button
Then select the Remove tab and choose a table in the combo box “Table”.
In the below box, fills the conditions required for considering a record as a duplicate. The Threshold value must be between 0 and 1. You can choose more than one condition.
In the output box, select the output fields that you require display and then click on the Query button.
To delete the duplicate records check the box in the Remove column and press click on the Delete button.
To join two tables
Perform the first two steps above, you can load more than one data source at a time.
Press click on the Join tab and select the tables you want to join in each of the two combo box.
In the below box, fills the conditions required for considering two records as equals. The Threshold value must be between 0 and 1. You can choose more than one condition.
In the output box, select the output fields you require display of each of the two tables, and then click on the Join button.
To delete wrong records, check the box in the Remove column, and click on the Delete button.