cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
vitali_pom
Level I

JSL - How to remove formula from column?

Hi,

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

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: JSL - How to remove formula from column?

Below is another option:


dt = Open( "$SAMPLE_DATA/Bank Loan.jmp" );


:Time << Delete Formula;


Wendy

View solution in original post

5 REPLIES 5
Jeff_Perkinson
Community Manager Community Manager

Re: JSL - How to remove formula from column?

Try the  Delete Property() message to the column.


dt = Open( "$SAMPLE_DATA/Tiretread.jmp" );



:Pred Formula ABRASION << delete property(Formula);


-Jeff

-Jeff

Re: JSL - How to remove formula from column?

Below is another option:


dt = Open( "$SAMPLE_DATA/Bank Loan.jmp" );


:Time << Delete Formula;


Wendy
lwx228
Level VIII

Re: JSL - How to remove formula from column?

I just found it at this BBS:
Column(dt, "Values From Formula") << deleteFormula;
Zahti
Level I

Re: JSL - How to remove formula from column?

This is perfect for column names that have special characters in them, thanks!!

txnelson
Super User

Re: JSL - How to remove formula from column?

Or by using the :Name() function form

:Name("Values From Formula") << deleteFormula; 
Jim