Duplicates
Imports and list pulls often bring in the same person or company twice. Find duplicates groups the rows that share a key, keeps one row per group, and removes the rest in one step you can undo.
Find duplicates
- Open the header menu of the field to match on, for example Email.
- Pick Find duplicates….
- Optionally turn on Then match by for other fields, like LinkedIn or Website. Rows that share any of these keys are grouped too.
- Choose whether to keep the oldest row (the default) or turn on Keep the newest row.
- Click Preview. Appenda says how many duplicate rows will be removed and from how many groups.
- Click Remove duplicates.
Find duplicates is available on Text, URL, Email, Phone, Number, and select fields.
How rows match
Keys are compared after the same cleanup Appenda uses for each field type, so small differences in how a value was typed don't hide a duplicate.
| Field | These match |
|---|---|
[email protected] and [email protected] | |
| URL | https://www.acme.com/pricing and acme.com, matched on the company domain |
| URL with a LinkedIn link | The same profile or company, with different tracking or www |
| Text | The same words in a different case or spacing. A Text field of emails, LinkedIn links, or domains matches like those types |
A row with an empty key never matches on that key. Two rows without an email are not duplicates of each other, though they can still match on a Then match by field.
What happens to each group
- One row is kept: the oldest, or the newest if you chose that.
- Empty fields on the kept row are filled from the duplicates that have a value, so no data is lost.
- The other rows in the group are deleted.
- A group with a row that an enrichment is still writing is skipped. The preview says how many groups were skipped. Run it again when the enrichment finishes.
Undo
The removal is one entry in Table history. Undo brings back every removed row and the kept row's original values.
Related
FAQs
Which row is kept?
The oldest row in each group, unless you turn on Keep the newest row. Its empty fields are filled from the other rows first.
Does it look only at the rows in my view?
No. It checks every row in the table, so a duplicate hidden by a filter is still found.
Can I match on two fields together, like first and last name?
Not yet. Each field you add is its own key, and rows that share any one of them are grouped. Pick a field that identifies a row on its own, like Email or LinkedIn.