Dedupe Data by Multiple Columns: Company, Job Title, and Posted Date

Sunny D. · 2025-04-29T13:28:50.584259+00:00

How to dedupe based on multiple columns? Because duplication is not determined with only one column. Eg Company Name, job title, job posted Same company name might have a different job title and job posted. So I cant dedupe based on Company Name only.

To dedupe data based on multiple columns in Clay, you'll need to use a combination of methods: 1. For single column deduplication: • Click the column header you want to dedupe • Select 'Dedupe' from the dropdown menu • Confirm and select 'Delete' to remove duplicates 2. For multi-column deduplication: • Use the Auto-dedupe feature: i. Click the Auto-dedupe icon at the bottom right of your table ii. Select 'Enable automatic deduplication' iii. Choose the columns you want to dedupe iv. Click 'Save Changes' Remember, deduplication is case-sensitive and considers exact string matches, including whitespace. If you need further assistance, you can request human help by clicking on 'Talk to a person' in the chat.

Sources: Table columns | Documentation | Clay University Auto-update and Auto-dedupe Table

3 comments