turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Delete Columns with Formula Reference in JSL

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 24, 2013 11:20 AM
(5584 views)

Hi,

I have a script where I would like to delete columns that contain a formula reference. This is easy to do in JMP: when delete the unnecessary columns I get a "JMP Alert" and select "Remove Formula". I am then able to delete my metadata columns, but the table maintains the result calculated in the formula column.

My problem is: how can I script this? Is there an option to delete a metadata column that contains a formula reference? I am using JMP10. Please see the example below.

```
/*
bigClass = Open( "$SAMPLE_DATA/Big Class.jmp" );
bigClass << New Column( "height / weigh", Numeric, Continuous, Format( "Best", 12 ), Formula( :height / :weight ) );
bigClass << Delete Column( "height" );
bigClass << Delete Column( "weight" );
*/
```

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 24, 2013 11:24 AM
(9122 views)

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 24, 2013 11:24 AM
(9123 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 7, 2018 5:21 AM
(2136 views)

Can you tell me how you solved this problem? I have tried to remove formula, but this removed the values in the original column. I need to delete a column contains a column reference. Thank you.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 3, 2018 12:01 PM
(1889 views)

@DonHil Column("column name") << delete formula;