hey - I have a table that has somehow duplicated contacts, is there a way of me clearing that out? Its super annoying as I has enrichments running and now its blowing a bunch of credits on duplicated data.. know why this is happening?
You have several options to handle duplicate contacts:
1. Use Auto-dedupe (Beta):
• Click the Auto-dedupe icon at the bottom right of your table
• Select "Enable automatic deduplication"
• Choose the column to dedupe against
• Click "Save Changes"
2. Manual Column Deduplication:
• Click the header of the column containing duplicates
• Select "Dedupe" from the dropdown
• Confirm and select "Delete" to remove duplicates
Note when deduplicating:
** Deleted rows cannot be recovered
** Matches are case-sensitive
* Extra whitespace is considered in matching
The Auto-dedupe feature is specifically designed to keep your table clean and prevent accidentally enriching the same record multiple times.
Auto-dedupe is the way to go. If the data is in another table you can also use lookup.
If you'd rather not delete the data you can also use this method here.
Here's the formula as well: {{Unique ID}}?({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())> -1?{{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())+1:2):2
Regarding the refund of credits, happy to do so. How many was it? Just FYI we won't be able to do so anymore.