Filtering Data in Tables: How to Exclude Employees Below 500

Sunny D. · 2025-04-14T20:46:08.815138+00:00

I wanted to run my enrichment only on employees above 500. But write to table ran it for below 500 too. Which got me a lot of unwanted data and used my credits to enrich it on auto in the other table. I want to filter the data now in the other table to above 500. How do I do this? Pivot?

To filter your data to include only employees above 500, you can use conditional formulas or filtered views in Clay. Here's how: 1. Use a conditional formula: • Go to the enrichment column's "Run Settings" • In the "Only run if" box, add a formula like: {employee_count} > 500 2. Create a filtered view: • Set up a filter for employee count > 500 • This ensures only rows meeting your criteria are visible and enriched Using these methods will help you save credits by running enrichments only on the data you need. Remember, you're only charged for rows you enrich in your current view. If you need more assistance, please request human help by clicking "Talk to a person".

Source: Conditional Formulas

4 comments