cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Hegedus
Level IV

Data Filter to select missing

Hi,

 

I am attempting script a plot Y by X plot and constrain the rows to those missing in column Z.  I am modifying some existing code and the local filter is defined

as

 

  Add Filter( columns( :Fid_data_check ), Where( :Fid_data_check == "not found" ) )

but this depended on the creation of a column externally in Excel that was either "OK" or "Not Found".  I am moving the entire workflow to eliminate the need of Excel and would like to take advantage of the is missing values handling.

 

I am trying:

 Add Filter( columns( :Z ), Where( is missing(:Z) ) ),

The Log window says that:

Range value cannot be missing.

How do I need to modify the Add Filter line?

1 REPLY 1
Jeff_Perkinson
Community Manager Community Manager

Re: Data Filter to select missing

The best way to figure stuff like this out is to let JMP write it for you.

 

In the Data Filter there's a Select Missing option in the red triangle above a column.

 

8387_JMPScreenSnapz001.png

 

Turn that on and then save the filter script to a script window to see how to script it.

 

8388_JMPScreenSnapz002.png

 

 

Current Data Table() << Data Filter(
  Location( {838, -4} ),
  Add Filter( columns( :weight ), Display( :weight ), Select Missing( :weight ) )
);

 

 

 

-Jeff

-Jeff