Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
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
Highlighted

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
Highlighted
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
Highlighted

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

Highlighted
lwx228
Level VII

Re: JSL - How to remove formula from column?

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

Re: JSL - How to remove formula from column?

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

Highlighted
txnelson
Super User

Re: JSL - How to remove formula from column?

Or by using the :Name() function form

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

    There are no labels assigned to this post.