topic Re: How to concatenate files and preserve formula columns in Discussions

How to concatenate files and preserve formula columns

Thomas1 — Sun, 19 May 2019 15:48:20 GMT

I'd like to concatenate a main file withe a new file. The main file contains a formula column, the new file not. The resulting file should have the formula column with the formula from the main file.

Additional the new file should be renamed to the name of of main file and the the former main file and the new file should be closed and not saved.

Re: How to concatenate files and preserve formula columns

txnelson — Sun, 19 May 2019 16:02:25 GMT

The main part of the JSL below, was obtained by running the Concatenate platform interactively to get what was desired, and then taking the JSL from the Source of the new table and pasting it into the script.

Names Default To Here( 1 );
dtMain = Data Table( "MainFile" );
dtNew = Data Table( "NewFile" );
dtConcat = dtMain << Concatenate( dtNew, Keep Formulas );

concatName = dtMain << get name;

Close( dtMain, nosave );
Close( dtNew, nosave );

dtConcat << set name( concatName );

Re: How to concatenate files and preserve formula columns

JensRiege — Mon, 20 May 2019 01:48:31 GMT

Thanks txNelson for this useful post. I was just working on the exact same issue , and the "keep formulas" parameter solves my problem.

Re: How to concatenate files and preserve formula columns

Jeff_Perkinson — Mon, 20 May 2019 03:20:47 GMT

To avoid the creation of a new data table and having to deal with renaming you can use the Append to first table option.

Names Default To Here( 1 );
dtMain = Data Table( "MainFile" );
dtNew = Data Table( "NewFile" );
dtConcat = dtMain << Concatenate( dtNew, Append to first table, Keep Formulas );

Re: How to concatenate files and preserve formula columns

Thomas1 — Mon, 20 May 2019 07:58:55 GMT

Thanks Jim. That's what I was looking for.

Re: How to concatenate files and preserve formula columns

Thomas1 — Mon, 20 May 2019 08:00:42 GMT

Thanks Jeff. The append to ... command makes it even better.