How to Remove Rows in a Column Based on Values from Another Table

Grant H.

·

Hi, is there away to remove a row in a column by looking to see if a value is the same in another table?

5 comments

Grant H.
·
·
Effectively deduping if the value exists in another table
Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Grant H.
·
·
Deduping the url column in this table https://app.clay.com/workspaces/316859/tables/t_CXjG7ouufHys/views/gv_BeChc3G65Dk4## if the same URL exists in the linkedin address from this table https://app.clay.com/workspaces/316859/tables/t_WYY3bGBRCiyk/views/gv_nC4xBsCzSiEi
Daniela D.
·
·
Hey Grant! Thanks for reaching out. Happy to help. It's currently not possible to auto-dedupe records between tables, but you can run Lookup to identify duplicates in a table and if found, manually delete those records from the table. I added a Lookup column to your table to check for this. You can run it for all rows in your table. When the run is complete, you can filter your table to show rows that have results (see screenshot below) and delete those records from the table. To make it easier, you can also save a separate view for rows that return a matching record in the Lookup column. Here's a quick recording showing how to do this (filter is already saved in your table): https://share.cleanshot.com/xlTDSPp4 Here's a quick guide for using the Lookup feature: https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf Let me know if this helps. https://downloads.intercomcdn.com/i/o/1182562226/428308b9ff41e3702258fbe4/CleanShot+2024-09-17+at+11_08_16%402x.png?expires=1726570800&signature=479e6e03908ad7d197ecfa31f7a125cb6c8ff095a66676b954734b78cc7dea9e&req=dSEvFMx4n4NdX%2FMW1HO4zcuEFfsO9nZ3hUa6PREk0R6Ss1pOgoTJPdFUNVsw%0A%2FgFh%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.