![]() ![]() ![]() Fuzzy: Looks for typos and transposition errors (where characters are swapped such as ei vs ie in the word field)īe careful! Fuzzy matching can often result in false positive matches, since its search is so broad.Similar: Has the same value, but may have different capitalization, punctuation, accents, whitespace, or ordering of words.Exact: Has the same, case-sensitive value.Below is an explanation of what will be found by each matching type: If you pick multiple fields to find duplicates, the extension will find sets of records where the values match for all of the selected fields.įor text field types, you can choose to use exact matching, similar matching, or fuzzy matching. If you'd like, you can also choose to limit your search to a specific view to only find duplicates within a subset of records.Īfter that, you'll need to pick the field or fields that you want to use to find duplicates. Next, you'll need to pick the table in which you'll be looking for duplicates. To get started, first add a dedupe extension to your base by opening up the extensions panel and clicking the + Add an extension button. Consolidate leads that were accidentally added to your CRM multiple times.Convert a messy CSV into an Airtable base.Try using the dedupe extension when you want to: You can delete duplicates or merge individual fields from duplicate records together. The dedupe extension helps you find and manage duplicate records in a table. ![]() For large bases, the dedupe extension may be slow to review, merge, and delete records. ![]()
0 Comments
Leave a Reply. |