.png&w=3840&q=75){kind=logo}
Issue with Deduplication Using Company ID Column
Why can't I dedup based on my company ID column? https://app.clay.com/workspaces/295058/workbooks/wb_bQgMupE6aSKA/tables/t_7BQoJWyXSyPp/views/gv_MWvaZfwumMaf
You can deduplicate based on any column in your table. Here's how to do it:1. Click the Auto-dedupe icon at the bottom right of your table 2. Select "Enable automatic deduplication" 3. Choose your company ID column to dedupe 4. Click "Save Changes"This will ensure your table always has a unique set of records and helps keep your data clean. As an added benefit, this prevents duplicate enrichments, saving you credits by not enriching the same company multiple times.If you need to manually dedupe, you can also right-click the company ID column and select "Dedupe > Delete Duplicate Row". Sources: Auto-update and Auto-dedupe Table Auto-dedupe
It's not clear that you can only auto-dedeup on text (and not numbers)
The information I've found doesn't specifically address using auto-dedupe on numeric columns like company ID. Auto-dedupe is a feature that helps keep your data clean by removing duplicate records within a table.Currently, auto-dedupe is being rolled out in phases. In the initial phase, it's available for the LinkedIn URL column in Find Companies tables. Future phases will expand this feature to other tables and allow users to configure any column for auto-deduplication.To use auto-dedupe on a specific column:1. Select the Auto-dedupe icon at the bottom right of your table 2. Enable automatic deduplication 3. Select the column you want to dedupe 4. Click Save ChangesCan you provide more information about why you're specifically interested in using auto-dedupe on numeric columns like company ID? This will help me better understand your needs and provide a more tailored response. Sources: Auto-update and Auto-dedupe Table Auto-dedupe