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!
