Subscribe Bookmark RSS Feed

trying to make data table invisible

eveyja

Community Trekker

Joined:

Mar 8, 2016

I am trying to get rid of the popup data tables that are created when I make spline coefficients using the "spline coef()" function below.

I've tried lots of combinations of "invisible" and various syntax but can't seem to get the data table to disappear.  It pops up as "AOPMean_Spline" and if I don't name it that, it pops up with a default title.

Any ideas?  thanks!

-Jeff

dt = AOPMean_Subset;

Current Data Table (dt);

Y = Column( "Measurement Results with Conversion Formulas" ) << GetAsMatrix;

X = Column( "DateTime" ) << GetAsMatrix;

coef = Spline Coef( x, y, 1e+18 );

dtcoef = As Table(coef);

dtcoef << Set Name ("AOPMean_Spline");

Column( dtcoef, "Col1" ) << Set Name( "X" );

Column( dtcoef, "X" ) << Data Type (Numeric, Continuous, Format( "yyyy-mm-ddThh:mm:ss", 19, 0 ), Input Format( "yyyy-mm-ddThh:mm:ss", 0 ));

Column( dtcoef, "Col2" ) << Set Name( "A" );

Column( dtcoef, "Col3" ) << Set Name( "B" );

Column( dtcoef, "Col4" ) << Set Name( "C" );

Column( dtcoef, "Col5" ) << Set Name( "D" );

3 REPLIES
eveyja

Community Trekker

Joined:

Mar 8, 2016

It formatted my text with an "@" for some reason : I added a few spaces below to avoid this:

dt = AOPMean_Subset;

Current Data Table (dt);

Y = Column( "Measurement Results with Conversion Formulas" ) << GetAsMatrix;

X = Column( "DateTime" ) << GetAsMatrix;

coef  =  Spline Coef( x, y, 1e+18 );

dtcoef = As Table(coef);

dtcoef << Set Name ("AOPMean_Spline");

Column( dtcoef, "Col1" ) << Set Name( "X" );

Column( dtcoef, "X" ) << Data Type (Numeric, Continuous, Format( "yyyy-mm-ddThh:mm:ss", 19, 0 ), Input Format( "yyyy-mm-ddThh:mm:ss", 0 ));

Column( dtcoef, "Col2" ) << Set Name( "A" );

Column( dtcoef, "Col3" ) << Set Name( "B" );

Column( dtcoef, "Col4" ) << Set Name( "C" );

Column( dtcoef, "Col5" ) << Set Name( "D" );

ian_jmp

Staff

Joined:

Jun 23, 2011

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

m = dt << getAllColumnsAsMatrix;

dt2 = AsTable(m, << Invisible);

Wait(2);

dt2 << NewDataView;

Wait(2);

Close(dt2, NoSave);

eveyja

Community Trekker

Joined:

Mar 8, 2016

Thanks Ian, I found a different way around this but I'm sure your method works too!!