Vikrant R.

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Aaaah ok cool. Thanks for that update Bo (.! I'll take a look and get back

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Thanks Bo (.

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Mark L. Bo (. Can someone help please? My workflow is stuck 😕 because of this

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Thanks for the clarification Mark L.. I checked these out, and turns out these are edge cases (where the person has reposted the post twice). And it's ok if they get duplicated. But in most cases (more than 95%) of the time, the ShareURLs will be different because they are for different posts. The dedup doesn't work there as well. To show you the issue, I've resent the Send Table Data from Row 1. In an ideal scenario, it should keep the new rows and remove the old ones, but you can see in the table that all the rows appear as is.

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Hey Mark L. Thanks for that context. So the URLs that need to be deduped are unique LinkedIn post URLs. So they only come once when the data is sent to the other table. I want to run the post extraction column on a schedule, where it sends the newly extracted posts to the other table, and there it should get auto-deduped to only retain the new ones, and delete the old ones (because I want updated reactions as well). Since it's sending the data on a schedule, there isn't the problem of deduping records at the same time. So even when I send the data after sometime, the dedupe doesn't work. Please let me know if I can help clarify further.

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Mark L. Hey, yes these were manually removed.

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Hey Daniela D., can you please help?

Commented on Auto-Dedupe Feature Not Working on Table: Seeking...·Posted inClay Support

Vikrant R.

Hey Bo (. - Here's what's happening:

1.
I'm sending data from one table to another, let's assume from Table A to Table B.
2.
I have switched on auto-dedup with newest rows on one particular column (which has urls) in Table B.
3.
Now when I resend data from Table A to Table B (using Send Table Data) function, I want the newest rows with the URL to stay, but instead, it writes it to Table B and all the rows with duplicates are available there.
4.
So the auto-dedup function isn't working.
5.
I did try to switch it off and on again, but nothing changes.

Can you please help?

Posted in Clay Support·

Vikrant R.

Auto-Dedupe Feature Not Working on Table: Seeking Assistance

Auto-dedupe on Keep Newest Rows is not working. I can still see multiple duplicates in the table. Can you please help? Here's the table URL - https://app.clay.com/workspaces/479671/workbooks/wb_0t7thshuyAT25sbDBqD/tables/t_0t7v7kkC4NJVbY2Qwcy/views/gv_0t7v7kkXcHTuuXXegP7

16Comments

Commented on Seeking 1-Hour Clay Consultation for Workflow Deve...·Posted inShare Part Time Jobs

Vikrant R.

Hey John T., here's one way to do this -

1.
Let's assume you call your main table - Table 1 where you have all your scored data.
2.
Write all this data to another table, let's call that Table 2
3.
In Table 2, keep the auto deduplication on based on company domain. So now you have a list of all unique companies. So in your example, you only have 2 rows - Company A and Company B
4.
Now you can look up multiple rows in Table 2 from Table 1. This is a native Clay integration.
5.
When you run this, In Table 2, you should see the 2 rows with multiple outputs. So in your example, you'll see 2 outputs for Company A and 4 outputs for Company B.
6.
Now you can run an AI column on that output and only ask it to pick the top 2 prospects for each company.

Happy to help clarify how to make this work

About

Country
My Company Website
Title