BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
robot
Community Trekker

Delete Columns with Formula Reference in JSL

Hi,

I have a script where I would like to delete columns that contain a formula reference.  This is easy to do in JMP: when delete the unnecessary columns I get a "JMP Alert" and select "Remove Formula".  I am then able to delete my metadata columns, but the table maintains the result calculated in the formula column.

 

My problem is: how can I script this?  Is there an option to delete a metadata column that contains a formula reference?  I am using JMP10.  Please see the example below.

 

 

/*
bigClass = Open( "$SAMPLE_DATA/Big Class.jmp" );
bigClass << New Column( "height / weigh", Numeric, Continuous, Format( "Best", 12 ), Formula( :height / :weight ) );
bigClass << Delete Column( "height" );
bigClass << Delete Column( "weight" );
*/

 

 

Thanks!

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
robot
Community Trekker

Re: Delete Columns with Formula Reference in JSL

Never mind.  I found the answer:

 

https://community.jmp.com/message/48129#48129

0 Kudos
3 REPLIES 3
robot
Community Trekker

Re: Delete Columns with Formula Reference in JSL

Never mind.  I found the answer:

 

https://community.jmp.com/message/48129#48129

0 Kudos
DonHil
Community Trekker

Re: Delete Columns with Formula Reference in JSL

Can you tell me how you solved this problem?  I have tried to remove formula, but this removed the values in the original column.  I need to delete a column contains a column reference.  Thank you.

0 Kudos
powerpuff
Community Trekker

Re: Delete Columns with Formula Reference in JSL

@DonHil Column("column name") << delete formula;

0 Kudos