topic Re: Deleting Column Formula error by using Delete Property (formula) script. in Discussions

Deleting Column Formula error by using Delete Property (formula) script.

joelahn — Sat, 10 Jun 2023 23:19:07 GMT

Hi,

I have multiple columns with formula, and I wanted to remove formula after calculations.

codes are as below.

cols = dt << get column names();

For( i = 1, i <= N Col( dt ), i++,
    cols[i] << Delete Property( formula )
);

Then, the log says the following:

Send Expects Scriptable Object in access or evaluation of 'Send' , cols[i] << /*###*/Delete Property( formula ) /*###*/

Can somebody help on me this?

Another question is if we can make a list of specific columns and delete formula.

We have a script called "Delete Formula", I wanted to use this to column list, but it seems it's not working well.

Re: Deleting Column Formula error by using Delete Property (formula) script.

joelahn — Fri, 18 Sep 2020 10:27:58 GMT

cols = dt << get column names();

For( i = 1, i <= N Col( dt ), i++,
    As Columns( cols[i] ) << Delete Property( formula )
);

Putting As Column() has resolved this. Yet I still have wonders why it did work a few times, then later on it didn't work - with same JMP versions (I use both 15, and 16EA).

Re: Deleting Column Formula error by using Delete Property (formula) script.

txnelson — Fri, 18 Sep 2020 08:51:06 GMT

cols = dt << get column names();

For( i = 1, i <= N Col( dt ), i++,
 column(cols[i]) << Delete formula;
);

//or

For( i = 1, i <= N Col( dt ), i++,
 column(i) << Delete formula;
);