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
Go to Solution
try dt << Select Where(Is Missing(:A));
This works for character and numeric data types.
View solution in original post
Thanks for quick reply. It works fine now.