cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

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

miguello
Level VI

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?

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User


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

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,

txnelson_0-1741231514669.png

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

txnelson_1-1741231641261.png

 

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User


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

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,

txnelson_0-1741231514669.png

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

txnelson_1-1741231641261.png

 

Jim
miguello
Level VI


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

🤦

 

Of course!

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

 

Thanks!