230824_en-US

liliconcom

Delete formula status without deleting values

Hello,

I have a for loop for calling formulas from a file.

The loop works fine but when I try removing the formula and maintaining the created values using

<

or

<

 

the formula is removed but the values are all gone as well.

This happens for both JMP 11 and 14.

can you please help?

 

loop:

 

formula_table = Open( formula table adress, Worksheets( "Formulas" ), Invisible );
//open data table

 For( i = 1, i <= N Rows( formula_table ), i += 1,

 col = data << New Column( formula_table:Column Name[i]/*, Eval( formula_table:Type[i] )*/ );
  If(
   formula_table:Type[i] == "Character", col << Data Type( Character ),
   formula_table:Type[i] == "Numeric", col << Data Type( Numeric )
  );
  a = Concat( formula_table:Formula[i] );
  a = Parse( a );
  col << Formula( a ); // sets formula
  col << delete formula;//doesn't work as described above
 );
 Close( formula_table, NoSave );

Thanks

 

 

 

Re: Delete formula status without deleting values

I prefer to just <

 

Names default to here( 1 );
dt = open("$SAMPLE_DATA\Big Class.jmp");
f = expr(:height/:weight);
Eval(EvalExpr( // doing this so it doesn't just keep the "f" var there
 dt << New Column("SetEach", 
  <<SET each="" value=""></SET>

Re: Delete formula status without deleting values

I suggest using this dedicated message:

 

Re: Delete formula status without deleting values

I've had the same issue this morning and had to place a wait before the delete formula line. 

 

wait(0);
:CoatingTime << Delete property(Formula);

Before placing the 'wait(0)', my column values were deleted as well. 

Re: Delete formula status without deleting values

Here is a simple example showing that the

      col << delete property(formula);

works.  

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

col = dt << New Column( "zippy", formula( Row() ) );

col << delete property( formula );

Re: Delete formula status without deleting values

I don't think there is, but it doesn't take much to delete the formula from a column list.

 

For Each( {v, i}, collist, v << Delete Formula );

Re: Delete formula status without deleting values

You can use Standardize Attributes for this.

 

Use the bottom part of the dialog to Delete the Formula property.

 

 Admittedly it is a bit confusing because after adding "Formula" you see a Remove button appear. That Remove is to remove the Formula entry from the Delete Properties section not to Remove the formula from columns. To remove the formula from the columns you have to click the OK or Apply button for the dialog.

 

Re: Delete formula status without deleting values

On the same note, is there a command for deleting formulas from multiple columns?

I would like to delete existing formulas in a table without deleting the values in columns. 

 

I was trying to remove formulas by using the standardize attributes and remove formula, but nothing happened.

 

Thank you.

Re: Delete formula status without deleting values

Had the same problem, wait solved it! Thanks!