Understanding Query Duplicates in Clay Workspaces

Brandon H. · 2025-04-29T18:10:56.955267+00:00

Hi team, why am I getting dupes on the query? https://app.clay.com/workspaces/404639/workbooks/wb_amsbzP3JSQVJ/tables/t_2pDcj38cwHYE/views/gv_QmDkB8aMqTqA

To prevent duplicates in your Salesforce Reports query, you can use the "Uniqueness Fields" input. This allows you to select specific fields as unique identifiers for each row. To set this up: 1. In your Salesforce Reports integration, locate the "Uniqueness Fields" input. 2. Select the fields that, when combined, uniquely identify each record. 3. Save your changes and run the query again. If you're still experiencing issues, you can enable auto-deduplication for your table: 1. Click the "Auto-dedupe" icon at the bottom right of your table. 2. Select "Enable automatic deduplication". 3. Choose the column to dedupe. 4. Click "Save Changes". If you need further assistance, please request human support by clicking on "Talk to a person".

Sources: Auto-update and Auto-dedupe Table Salesforce Reports with Salesforce

2 comments