Automate copying table scripts when rerunning "source"

sowiakg

Hi,

I am creating a database in Excel that will be continually updated. New rows and columns will be added periodically, and existing rows will occasionally have new data added. As such I have started making use of the "Source" script to update the corresponding downstream JMP table.

The question I have is, is there a way to bring over any existing table scripts to the updated table when running the Source script? I have a number of graph builder scripts saved to the JMP table and would like to automatically copy them over to the new table each time the Source script is run. I use JMP version 17.

Thank you!

txnelson

Welcome to the community.

Here is an example of the code required to copy all of the table scripts from one data table to another, minus the Source table script.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
names=dt<<get table Script names;
remove from(names,1,1);
dt << Select Properties( names );
proplist = dt << Get Selected Properties();
dt2 = New Table( "Little Class" );
dt2 << Add scripts to table( proplist );

You would have to add this methodology to your Source script, or run it as a separate script to do what you are trying to do.

You can find details and examples of the different elements in this script in the Scripting Index under the Help pull down menu