The result table from my script is essentially 2 columns: "Position" and "N Rows". This table is a summary of a table that was created during the long add-in, and not a summary of any columns in the main table. I cannot use any scripts that create tables using data from the current table (such as summary, stack, etc.). I need to somehow save the exact values in the result table to a script that I can save onto my main table. Something like this:
New Table( "Positions of'n-1 base'",
Add Rows( 32 ),
New Column( "Position",
Numeric,
"Nominal",
Format( "Best", 10 ),
Set Values(
[1, 2, 3, 6, 8, 9, 11, 16, 18, 21, 23, 25, 26, 27, 28, 29, 30, 31, 32,
34, 35, 36, 37, 38, 39, 40, 41, 46, 48, 63, 65, 68]
)
),
New Column( "N Rows",
Numeric,
"Continuous",
Format( "Fixed Dec", 20, 0 ),
Set Values(
[13, 52, 65, 52, 65, 65, 65, 52, 52, 65, 52, 31, 28, 23, 13, 21, 14, 17,
9, 5, 4, 56, 1, 4, 5, 3, 55, 65, 65, 52, 13, 13]
)
)
)
But I can't figure out how to do that within my script. I don't know how to get this script, or save it to the main table.
My plan was to immediately get the script when the result table first opened and save it to a new table script on my main table, that way if the result table was closed, it could be re-created using the main table script.
Does that make more sense?