Filter and Enrich High Fit Companies in Clay Without Exporting

Nitin Balodi · 2025-06-06 19:47:33.062851+00

I have a column in the table that tells whether a company is High, Medium, or Low fit on the basis of a few criteria. Now I want to create another table but only want to keep the HIgh Fit companies and run enrichment to find leads in those companies. How can I do that in clay? One way is to export the csv and then re-upload it again with only the High Fit accounts. Can I do it without the export thingie?

Filter and Enrich High Fit Companies in Clay Without Exporting | Clay

6 comments

· Sorted by Oldest

Channeled
APP
·
·
You can create a new table with only High Fit companies without exporting by: 1. Create a filtered view in your current table showing only High Fit companies 2. While in this filtered view, click "Add enrichment" in the top-right corner 3. Select the enrichment you want to run 4. Choose "write to table" and select "Create new table" This will create a new table containing only your High Fit companies, and you can run enrichments directly on this new table.
Sources: Guide: Ways to save Clay credits | Documentation | Clay University Table management settings | Documentation | Clay University Table columns | Documentation | Clay University Table management settings | Documentation | Clay University
🙌1
Nitin Balodi
·
·
Thanks, that worked. I also want to import value from a column in my previous table to the new table -- kinda sorta like H/Vlookup in excel. Is that possible? To be more specific, I have a Fit Reason in the old table. I want to import that to the new table.
Channeled
APP
·
·
You can use our "write to table" feature to import your "Fit Reason" column from the previous table to your new table. Here's how: 1. In your new table, click "Add enrichment" 2. Search for and select "Write to Other Table" 3. Select your Clay account 4. Choose your source table (the one with the "Fit Reason" column) 5. Enter "/" to skip list selection 6. Map the columns - select "Fit Reason" from your source table and match it to the appropriate column in your destination table 7. Optionally configure auto-update settings This works similarly to VLOOKUP in spreadsheets, transferring specific column data between tables.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Nitin Balodi
·
·
No, there is no option like Write to Other Table in the enrichment. I used Lookup SIngle Row option but it isn't working
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.
Nitin Balodi
·
·
Found another way to get the column value. Thanks

Channeled
APP
·
·
You can create a new table with only High Fit companies without exporting by: 1. Create a filtered view in your current table showing only High Fit companies 2. While in this filtered view, click "Add enrichment" in the top-right corner 3. Select the enrichment you want to run 4. Choose "write to table" and select "Create new table" This will create a new table containing only your High Fit companies, and you can run enrichments directly on this new table.
Sources: Guide: Ways to save Clay credits | Documentation | Clay University Table management settings | Documentation | Clay University Table columns | Documentation | Clay University Table management settings | Documentation | Clay University
🙌1
Nitin Balodi
·
·
Thanks, that worked. I also want to import value from a column in my previous table to the new table -- kinda sorta like H/Vlookup in excel. Is that possible? To be more specific, I have a Fit Reason in the old table. I want to import that to the new table.
Channeled
APP
·
·
You can use our "write to table" feature to import your "Fit Reason" column from the previous table to your new table. Here's how: 1. In your new table, click "Add enrichment" 2. Search for and select "Write to Other Table" 3. Select your Clay account 4. Choose your source table (the one with the "Fit Reason" column) 5. Enter "/" to skip list selection 6. Map the columns - select "Fit Reason" from your source table and match it to the appropriate column in your destination table 7. Optionally configure auto-update settings This works similarly to VLOOKUP in spreadsheets, transferring specific column data between tables.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Nitin Balodi
·
·
No, there is no option like Write to Other Table in the enrichment. I used Lookup SIngle Row option but it isn't working
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.
Nitin Balodi
·
·
Found another way to get the column value. Thanks