.png){kind=logo}
Filters for Checking NULL Values in Queries
how can I put equal to NULL in the filters 'is empty' does not seem to work:
If 'is empty' isn't working for you, there are a couple of things you can try: 1. For text columns, use the 'is empty' filter option. This identifies records where the field is blank. 2. For number columns, you can also use the 'is empty' filter option. This filters records where the field is blank or missing. 3. If these options don't work, try using the 'equal to' filter and leave the value field blank. This might catch NULL values in some cases. If you're still having issues, it might be a data-specific problem. In that case, you may want to request human assistance for a more detailed look at your specific table and data.
Ram··does not work on table: https://app.clay.com/workspaces/25609/workbooks/wb_pHfFuSE7JcKe/tables/t_qBfsBcnCCvg8/views/gv_QnFaKioByD5h when I filter on is_empty I should be getting many results and I get none
Owen C.··Hey there, thanks for reaching out! What makes you consider that there should be empty values here? After quickly scrolling through this table, 100% of the rows in this column that I saw had full names. Just wanted to check and make sure we're not chasing our own tail here! :)