Skip to main content Skip to complementary content

Executing the Job

Procedure

Save your Job and click F6 to execute it.

Results

tFuzzyUniqRow uses the Levenshtein method to compare each of the three defined columns separately, it uses the Double Metaphone method to compare data in the City column, and finally passes the unique and duplicate rows to the defined output files. In our example, the first two rows match, hence the second row will go in the "duplicates" output.

The generated FID column gives a reference identifier of the original record which the current record refers to.

The third row is unique and will go in the "uniques" output.

The generated UID column is an identifier generated for the main record.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!