350912_en-US

liliconcom

saving script to data table issue

HI all,

 

I have written a script (a few hundred lines) that 1)  opens an existing data table, 2) does a whole bunch of calculations and then 3) spits out a new data table with results from these calculations. Because I am continually improving the script, I want to make sure that I know which exact version of the script was used to create the new output data table and so thought of saving the whole script to the data table. I tried using NewDt<

 

Regards and thanks, Yves 

Data TableScriptingRe: saving script to data table issue

Here is a simple script that will show you one way to do this

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

biv = dt << bivariate( x( :height ), y( :weight ) );
theScript = Char( biv << get script );

Eval( Parse( "\[dt<<NEW script=""></NEW>

Re: saving script to data table issue

Thanks Jim but I don't think that it solves my problem. My issue is more like the following:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
m = dt << Get All Columns As Matrix();

Several lines of matrix algebra with the columns of m producing various vectors y1, y2, y3

dt2=as table(y1, y2, y3);

I want to entire script above to be saved to dt2. Thanks again, Yves

 

Re: saving script to data table issueSo the question is, where does the script elements come from that you need to put together to build the literal string I called, "theScript". So where does what you call the "full script" come from?