Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Filtering Data in Tables: How to Exclude Employees Below 500

·

·

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?

Filtering Data in Tables: How to Exclude Employees Below 500 | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
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
Sunny Dsouza
·
·
I want to pivot it with the other table
LuisArturo (Clay)
·
·
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?
(52 kB)
Channeled
APP
·
·