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
AT
AT
Level V

Delete rows of an empty column

I like to delete the rows of a table when a colum is empty. Here is the script:

dt = Current Data Table();

dt << select where (:A == ""));

dt << delete rows;

 

No rows gets deleted. Please help. Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
cwillden
Super User (Alumni)

Re: Delete rows of an empty column

try dt << Select Where(Is Missing(:A)); 


This works for character and numeric data types.

-- Cameron Willden

View solution in original post

2 REPLIES 2
cwillden
Super User (Alumni)

Re: Delete rows of an empty column

try dt << Select Where(Is Missing(:A)); 


This works for character and numeric data types.

-- Cameron Willden
AT
AT
Level V

Re: Delete rows of an empty column

Thanks for quick reply. It works fine now.