Issue With Filtering Rows by Blank Email ID and Not Found Status

I am trying to filter out the rows with blank email ID. it is filtered on "Is empty". Not sure why its not filtering. I also tried to filter on the column "work email provider" when it contains "not found". Then as well it shows empty. Is there an issue with the website? Table Link: https://app.clay.com/workspaces/480573/workbooks/wb_JbcE7th9GYFv/tables/t_B6viNxTkevCA/views/gv_cSVCqJVhcsVF

6 comments

Channeled
APP
·
·
The issue you're experiencing with filtering might be due to the timing of data updates. Here are a few things to check: 1. Ensure all data is updated before applying filters. 2. Re-update the data in your table. 3. For future reference, consider adding a conditional run setting to only process rows when all variables are present. To filter effectively: 1. Use the "Filter" feature in your table. 2. Select the email column and choose "Is empty" as the condition. 3. For the "work email provider" column, use "Contains" with "not found" as the value. If the problem persists, you may need to review your data or table settings. For more detailed guidance on filtering, check our documentation on hiding, re-ordering, sorting, filtering, and merging columns.
Source: AI Formulas + Conditional Runs [Clay 101] - Clay University
LuisArturo
·
·
Hey there Sahil thanks for reaching out to clarify this is for the Relevant people table correct?
Sahil S.
·
·
yes LuisArturo
Owen C.
·
·
Hey Sahil, thanks for reaching out! If a filter isn’t showing any rows, it simply means that none of the rows meet the conditions set by the filter. After trying to replicate this on my end, I’m seeing that all 446 rows contain emails (as shown in the second image). I’m wondering if this might have been mixed up with a different part of the email waterfall (first image). Since all emails were found, there should be data providers for them, meaning the scenario where emails are both "not found" and confirmed to exist at the same time wouldn’t be possible. Hope this helps! Let me know how I can best assist. :)
(175 kB)
(157 kB)
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Sahil S.!

Issue With Filtering Rows by Blank Email ID and Not Found Status | Clay