.png){kind=logo}
Delete Rows Based on Filter or Column Value in Data Management
Hey there, Is there a way to delete rows based on a filter or a column value? I want to keep rows with the status value "valid" and delete the rest.
Hey there, Is there a way to delete rows based on a filter or a column value? I want to keep rows with the status value "valid" and delete the rest.
Currently, Clay doesn't have a direct "delete rows" feature based on filters. However, you can effectively manage this by: 1. Creating a filtered view of your data: • Click Filter above the table • Select your status column • Choose "equal to" and enter "valid" This will show only the rows with "valid" status. You can then: ** Work exclusively with this filtered view ** Create a dedicated export view with only these filtered rows * Export only these filtered rows to CSV for use elsewhere If you're seeing empty rows after filtering, try clearing your cache and refreshing your screen as this might be a temporary display issue.
I have prospect info with full name, domain etc in table 1. I have their email with full name and emails in table 2. Now, I want to write the emails from table 2 to table one, but only the emails with 'valid' status. Give me detailed instructions for this.
You can use the "write to table" feature to transfer emails with 'valid' status from table 2 to table 1. Here's how:
1. Open your Clay workbook containing both tables
2. Add a new enrichment to table 2
3. Search for and select "Write to Other Table"
4. Select your Clay account (or set up with your API key if not already connected)
5. Choose table 1 as your destination table
6. Enter "/" to skip list selection (since you're mapping columns, not lists)
7. Map the columns:
• Match the email column from table 2 to the appropriate column in table 1
• Map the full name column to ensure proper matching
8. Set up a conditional run by clicking "Run Settings" and "Only run if"
9. Create a condition like: IF(status = "valid") return true ELSE return false
This will only transfer emails marked as 'valid' from table 2 to the corresponding rows in table 1 that match by full name.