topic concatenate / save and evaluate formulas in Discussions

concatenate / save and evaluate formulas

Mauro_Gerber — Thu, 29 Aug 2019 09:46:37 GMT

When manually concatenate two tables there is an option to “save and evaluate formulas” so the formulas in the new or appended date gets evaluated.

In JSL this option is not available only “keep formula” witch suppresses the evaluation.

dt_1 << Concatenate(dt_2,Append to first table,save and evaluate formulas(1)); // this is not possible

I know that you can use:

dt_1:mycol << Suppress Eval( 0 );
dt_1:mycol << Eval Formula(1);

To get tho the same result as with the manual option, but I must search and do this for each column with a formula.

Is there a hidden function or plans to include it in Concatenate as an option?

Re: concatenate / save and evaluate formulas

Jeff_Perkinson — Thu, 29 Aug 2019 09:53:08 GMT

Keep Formulas does not supress the evaluation as far as I can tell.

Try this script and see that the formula in Row No is evaluated in the resulting table.

dt1 = New Table( "One Table",
	Add Rows( 10 ),
	New Column( "Row no",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Formula( Row() )
	)
);

dt2 = New Table( "Another Table",
	Add Rows( 10 ),
	New Column( "Row no",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Formula( Row() )
	)
);

Data Table( "One Table" ) <<
Concatenate(
	Data Table( "Another Table" ),
	Keep Formulas,
	Create source column
);

Re: concatenate / save and evaluate formulas

Mauro_Gerber — Thu, 29 Aug 2019 13:09:34 GMT

THX for your quick reply, your example works fine, I even preset the column to "supress eval" and it evaluate it after the concat.
So my table has a formula, but it's not executed and is still supressed after the concat. I found earlyer a mention that it could be a time issue that the table hasn't time to evaluate the column and is somehow stuck. I will investigate further.

Re: concatenate / save and evaluate formulas

Mauro_Gerber — Thu, 29 Aug 2019 14:00:15 GMT

I could follow the datamanipulation and found the "problem"

I make a subset of an existing data table and clear all the data which locks the formula column and suppresses the evaluation.

Then filling the table with data, but the formula stays empty.

I concatenate multiple of the same tables (append to first table). If the master table has a supressed eval, concat tables are not evaluated either.

Allow evaluation of the subset solved the problem.

dt_2 = dt << Subset(Output Table( "temp" ),Selected Rows( 0 ),Rows( [1] ),Selected columns only( 0 ),copy formula(1),link to original data table(0),Suppress formula evaluation( 0 ));

Concat dt_2 has then formula evaluation enabled.