Formula massages to data table

ram_asra_gmail_

Hi All,

I have thousands of formula columns to create and delete the formulas from those columns.

so to speed up the process i add formula in following ways.

dt<<Suppress Formula Eval(1);

for loop (

new col (formula);

dt<<Suppress Formula Eval(0);

dt<<Run Formulas;

);

2nd for loop

for loop (Try(column(dt,Newcolname[ik]) << delete formula));

Is there a way to send delete formula massage to datatable instead of to each columns.

since for loop to delete the formulas is taking more than 5 additional minutes.

Any work around is highly appreciated. supercomputer is not an option.

ms

A workaround I come to think of is to make use of the formula deleting power of Concatenate(). The code below creates a copy of the data table – including any table variables or scripts – but without formulas. 

dt = Current Data Table();// Table with formulas to delete

new_dt = dt << Concatenate(dt_temp = New Table("temp", New Column("deleteme")));

new_dt << delete column("deleteme");

Close(dt_temp, nosave);