- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Deleting columns
I am creating a bunch of new columns in a jmp datasheet and generate a summary table. I am doing all of this as a JMP script. Then I delete the new columns manually, exclude certain rows based on values in a column (manually) and rerun the earlier script. Is there a way to have jmp delete specific columns and exclude specific rows for me, as a script, instead of doing it manually?
Thanks,
Ravi
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Deleting columns
Something like this should work: (though it may be more complicated depending on the condition you're using to exclude rows)
dt = data table("Your Table Name");
dt<< delete column(column("1st Column to Delete"));
dt<< delete column(column("2nd Column to Delete"));
dt<<select where(/*condition for excluding*/);
dt<<exclude;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Deleting columns
hay Ravi,
i thin there is a way, by what criteria do you want do to this? will need more information to help you.
ron
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Deleting columns
Something like this should work: (though it may be more complicated depending on the condition you're using to exclude rows)
dt = data table("Your Table Name");
dt<< delete column(column("1st Column to Delete"));
dt<< delete column(column("2nd Column to Delete"));
dt<<select where(/*condition for excluding*/);
dt<<exclude;