Clay Icon
Join the Community
02 Support

How to Remove Duplicate Rows in Data Based on a Column

Avatar of Moritz H.Moritz H.
·
·

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

  • Avatar of Channeled
    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.