cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

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