User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
jmpandvba
jmpandvba
Level II

script for deleting all columns and rows in a data table

Created: Aug 10, 2018 12:54 PM  |  Last Modified: Aug 10, 2018 9:55 AM (5348 views)

How can I select all data in a data table (all rows and columns) and delete it through a script? 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
cwillden
Super User (Alumni) cwillden
Super User (Alumni)
Solution

Re: script for deleting all columns and rows in a data table

Aug 10, 2018 02:15 PM (5480 views)  |  Posted in reply to message from jmpandvba 08-10-2018 
dt = Current Data Table();
dt << Select All Rows() << Delete Rows;
-- Cameron Willden

View solution in original post

1 REPLY 1
cwillden
Super User (Alumni) cwillden
Super User (Alumni)
Solution

Re: script for deleting all columns and rows in a data table

Aug 10, 2018 02:15 PM (5481 views)  |  Posted in reply to message from jmpandvba 08-10-2018 
dt = Current Data Table();
dt << Select All Rows() << Delete Rows;
-- Cameron Willden

Recommended Articles