How to Remove Duplicate Rows in Data Based on a Column

·

Clay Hi Clay, I have duplicate values in one of my columns (e.g. 'Company Name') and I want to remove the duplicate rows from my table. What’s the best way to deduplicate the data in Clay so that only unique rows remain based on that column?

1 comment

· Sorted by Oldest

Channeled
APP
·
·
To deduplicate data in Clay based on a specific column like 'Company Name', you can use the column deduplication feature. Here's how: 1. Click on the header of the 'Company Name' column. 2. Select 'Dedupe' from the dropdown menu. 3. Confirm the duplicate values you want to remove and click 'Delete'. Keep in mind: ** Deleted rows can't be recovered, so proceed carefully. ** Deduplication is case-sensitive and considers extra whitespace. Alternatively, you can set up auto-dedupe: 1. Click the Auto-dedupe icon at the bottom right of your table. 2. Select 'Enable automatic deduplication'. 3. Choose the 'Company Name' column to dedupe. 4. Click 'Save Changes'. This will continuously monitor and remove duplicates, keeping only the oldest row.
Sources: Table columns | Documentation | Clay University Auto-update and Auto-dedupe Table

Channeled
APP
·
·
To deduplicate data in Clay based on a specific column like 'Company Name', you can use the column deduplication feature. Here's how: 1. Click on the header of the 'Company Name' column. 2. Select 'Dedupe' from the dropdown menu. 3. Confirm the duplicate values you want to remove and click 'Delete'. Keep in mind: ** Deleted rows can't be recovered, so proceed carefully. ** Deduplication is case-sensitive and considers extra whitespace. Alternatively, you can set up auto-dedupe: 1. Click the Auto-dedupe icon at the bottom right of your table. 2. Select 'Enable automatic deduplication'. 3. Choose the 'Company Name' column to dedupe. 4. Click 'Save Changes'. This will continuously monitor and remove duplicates, keeping only the oldest row.
Sources: Table columns | Documentation | Clay University Auto-update and Auto-dedupe Table