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
I want to pivot it with the other table
Hey there Sunny thanks for reaching out, sorry for the delay here, do you mind sending the link (url) to the table so we can take a look?