Paste Table Script into Script

aallman

I am trying to save a script to my data table that will recreate a table I made previously. This is an add-in that is pretty extensive and involves opening/closing several different tables, creating summary tables, joining, updating and in the end the only data I will need for the reports is a simple 2 column table. I would like the users to be able to run this add-in one time, and if they accidentally close the resulting table, they will not have to run the add in again because there will be a script saved onto the original table that can recreate the final table and analysis window. 

Hopefully that makes sense!

The problem I am running into is that the final table is a summary of one of the many tables created during the add-in script. So if I use the <<Get Table Script function, the result is "Data Table that no longer exists"<<Summary......etc. I want to use the <<Copy table script function, because it actually saves the column names and the values in each cell, which is exactly what I want! However, I can't figure out how to do this within my add-in script. Copy Table Script does not return anything that can be saved as a variable or expression, only copies the information to the clipboard so that it can be pasted later. 

sum<<Delete scripts("Source");
script=sum<<copy table script;
	
dt<<New Script("Positions Table", script);

This is an example of one thing I have tried that didn't work. dt is the original table that I would like to save this script to. sum is the table I want to recreate within the script.

Is this even possible???

SDF1

Hi @aallman,

 

  I'm a little confused as to what exactly you are attempting to do, but it does sound somewhat similar to something I've done before, where I needed to Stack the source data table and then tabulate the output data table, but didn't want to have to re-script everything when I concatenated some new data to the source data table.

 

  Here's some example code of the where I have the Stack script written in the source dt.

Data Table( "Analysis" ) << Stack(
	columns(
		:X1,
		:X2,
		:X3,
		:X4,
		:X5,
		:X6
	),
	Source Label Column( "Test Apparatus" ),
	Stacked Data Column( "Data" )
);
Current Data Table() << Set Name( "Data Stack" ) <<
New Script(
	"Fit Y by X of Data by Source",
	Oneway(
		Y( :Data ),
		X( :Source ),
		Means( 1 ),
		Mean Diamonds( 1 ),
		By( :Test Apparatus )
	)
);
Data Table( "Data Stack" ) << New Column( "Date-Time",
	"Ordinal",
	Formula( :Date + :Time ),
	Format( "m/d/y h:m:s" )
);
Data Table( "Data Stack" ) << Group Scripts(
	"Run these after stacking",
	{"Tabulate by Lot (run after stacking)",
	"Tabulate by Apparatus (run after stacking)"}
);
Data Table( "Data Stack" ) << Move Script Group(
	"Run these after stacking",
	to last
);

  And it will carry-over the scripts to the newly stacked data table. I also have saved to the main dt the grouped scripts with the title "Run these after stacking", which also get carried over to the newly stacked data table.

 

  I imagine that you might be able to approach your problem in a similar fashion.

 

Good luck!,

DS