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
- :
- JSL - How to remove formula from column?

- 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
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jul 13, 2014 1:27 AM
(7516 views)

Hi,

How can I remove a formula from a column without changing it through JSL?

Thanks.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jul 16, 2014 7:24 AM
(11530 views)

Below is another option:

dt = Open

("$SAMPLE_DATA/Bank Loan.jmp");:Time <<

Delete Formula;

Wendy

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jul 13, 2014 6:49 AM
(6000 views)

Try the Delete Property() message to the column.

dt = Open

("$SAMPLE_DATA/Tiretread.jmp");:Pred Formula ABRASION <<

delete property(Formula);

-Jeff

-Jeff

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jul 16, 2014 7:24 AM
(11531 views)

Below is another option:

dt = Open

("$SAMPLE_DATA/Bank Loan.jmp");:Time <<

Delete Formula;

Wendy

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 19, 2018 3:00 AM
(627 views)

I just found it at this BBS:

Column(dt, "Values From Formula") << deleteFormula;

Column(dt, "Values From Formula") << deleteFormula;