cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles