concatenate / save and evaluate formulas

Mauro_Gerber

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));&nbsp;//&nbsp;this&nbsp;is&nbsp;not&nbsp;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?

Jeff_Perkinson

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
);