topic Re: "Subset By" with a column that has empty values - how to ignore them? in Discussions

"Subset By" with a column that has empty values - how to ignore them?

miguello — Thu, 06 Mar 2025 02:54:54 GMT

I need to subset a table by a column with categorical values. Some rows have that By Column empty.

When I'm subsetting - how to NOT get any table where that By Column is empty?

Excluding and\or hiding those rows doesn't help, and I don't want to delete those rows.

Any other way?

txnelson — Thu, 06 Mar 2025 03:27:30 GMT

The way I would do this is to go to the data table and select all rows that do not have missing values for the column in question,

and then in the Subset dialog box, specify to only use selected rows

miguello — Fri, 07 Mar 2025 05:10:29 GMT

🤦

Of course!

Select where not empty, subset with selected rows, then again subset by...

Thanks!