- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Delete rows of an empty column
Created:
Jan 3, 2018 06:17 PM
| Last Modified: Jan 3, 2018 3:19 PM
(6804 views)
| Posted in reply to message from AT 01-03-2018
try dt << Select Where(Is Missing(:A));
This works for character and numeric data types.
-- Cameron Willden
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Delete rows of an empty column
Created:
Jan 3, 2018 06:17 PM
| Last Modified: Jan 3, 2018 3:19 PM
(6805 views)
| Posted in reply to message from AT 01-03-2018
try dt << Select Where(Is Missing(:A));
This works for character and numeric data types.
-- Cameron Willden
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Delete rows of an empty column
Thanks for quick reply. It works fine now.