Custom Expression for Excluding All Empty Columns

Get Help
1

Hi,

How do i write a custome expression for excluding all empty columns?

thank you for the help

2

Hi @Oriel
I guess you mean excluding empty rows.
It depends what you mean about empty - if you mean NULL value, then currently no:
https://github.com/metabase/metabase/issues/12225 - upvote by clicking :+1: on the first post

3

thanks for the response.
Will give the thumbs up, but meant columns (yes null)…is there a way to do this automatically with filter?

4

@Oriel There’s no request to exclude empty columns based on the results. I think you would need to do this with a Native/SQL query. But then it sounds like the schema/structure of the table probably isn’t well optimized.

5

Thanks, will consider schema as well