topic Simplest way to save/use column formulas in Discussions

Simplest way to save/use column formulas

Anonymous — Mon, 02 Feb 2015 03:18:50 GMT

Hello,

I have created around 10 column formulas in a data table that I would like to save and use on other data tables in the future.

Wondering if there is a way to save and import these formulas without having to retype them each time.

Thanks,

Re: Simplest way to save/use column formulas

ian_jmp — Mon, 02 Feb 2015 12:10:43 GMT

One way would be to save the table you have with a new name ('Template'), then delete all the rows therein and save it again. You can then just append rows to this template when new data arrives.

If you want to look at individual formulas, you can 'Copy Table Script' from the red triangle of 'Template', then do 'File > New > New Script' and paste the contents there.

Re: Simplest way to save/use column formulas

Craige_Hales — Tue, 18 Oct 2016 22:26:43 GMT

Right-Click at the top of a formula column, pick Copy Column Properties. You can then Paste Column Properties in a new column. Try the copy and paste Multiple Column Properties; it might be what you are looking for. Select several formula columns first. Before the paste, make several new columns and select them. The paste buffer contains the text of the formulas, like this:

{Add Column Properties( Formula( :a + :p ) ),

Add Column Properties( Formula( :a - :p ) )}

and you could save that text for later. Re-copy it, then Paste Column Properties again.

or...

Copy and paste works in the formula editor (right-click at the top of the column, pick Formula Editor):

or...

You can also script the formula; use the red triangle at the top left of the table and Copy Table Script.

New Table( "Untitled 2",

Add Rows( 1 ),

New Column( "a",Numeric,"Continuous",Format( "Best", 12 ),Set Values( [1] ) ),

New Column( "b",Numeric,"Continuous",Format( "Best", 12 ),Set Values( [2] ) ),

New Column( "c",Numeric,"Continuous",Format( "Best", 12 ),Formula( :a + :p ) )

);

You can use the JSL editor to build scripts to make your tables with the formulas.

Re: Simplest way to save/use column formulas

Anonymous — Fri, 13 Feb 2015 20:25:41 GMT

Hi all,

I ended up writing a script with formulas to build new columns.

Copying Column Properties also worked, but it was a bit shaky if multiple columns were copied/pasted at once. Worked fine for one column copied at a time.

Thanks for the help!

Re: Simplest way to save/use column formulas

Anonymous — Wed, 10 Feb 2016 20:39:56 GMT

I use this technique frequently.

With my data table formulas in use, I create a subset of my data (first row) and copy table script. Paste it into a new script window and delete all of the data code, leaving just the formulas. With a bit of cleaning up, it works.