Question

Native Derived Table Filter

  • 12 January 2021
  • 1 reply
  • 41 views

Hello all,

How would I apply a NULL filter on a Native Derived Table using an explore source? I understand how to do this via SQL, but can’t figure it out for explore source. The image below is from the Looker webpage on how to use a filter. It appears to be a text based filter, so if I typed in IS NULL, it when only show me results that had a string of “IS NULL” whereas I just want all null records. Thanks for the help!

 

https://docs.looker.com/data-modeling/learning-lookml/creating-ndts

 


1 reply

Userlevel 1

try “NULL”

 

this doc shows examples of many filter expressions include null and not null https://docs.looker.com/reference/filter-expressions

 

Reply