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.
Choose Language Hide Translation Bar
Samuel11
Level I

Delete whole row if one cell is missing

I am trying to reduce the number of rows.
I need a function where if Column 3 have any empty cell , it will delete the whole row.
here is a picture of the table 
in this case Column 3 name is (Row 4)

Samuel11_0-1579740843062.png

 

1 REPLY 1
txnelson
Super User

Re: Delete whole row if one cell is missing

names default to here(1);
dt = current data table();
dt << select where(:Row 4 == "" );
dt << delete rows;
Jim