.png){kind=logo}
Understanding Query Duplicates in Clay Workspaces
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
I don't want to dedupe after the fact. All the pulls are dupes
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".