Subscribe Bookmark RSS Feed

JSL: How to close data tables after analysis

SamH

Contributor

Joined:

Mar 3, 2017

I am new to JSL just started 2 weeks ago.

 

I am trying to create analysis for many tests, few tests are stacked togehter at a time in a new data table everytime; by the time the script is done I end up with many opened data tables. I cannot close these data tables after the analysis is done. is there a way to close these open files without closing the original data file or the actual chart?

 

Because now, I am ending up with over 30 data files, named test, test1,...

 

here is a snap of my code:

 

dt = Current Data Table();
NW = New Window( "TRIM_CHARTS",
           
dt << Stack(
            columns(
                  :TRIM_TARGET,
                  :Emulate_0000__,
                  :Emulate_0001__,
                  :Emulate_0010___,
                  :Emulate_0011__,
                  :Emulate_0100__,
                  :Emulate_0101__,
                  :Emulate_0110__,
                  :Emulate_0111__,
                  :Emulate_1000__,
                  :Emulate_1001__,
                  :Emulate_1010__,
                  :Emulate_1011__,
                  :Emulate_1100___,
                  :Emulate_1101__,
                  :Emulate_1110___,
                  :Emulate_1111__,
                  : _BEST_VALUE
            ),
            Source Label Column( "Label" ),
            Stacked Data Column( "Data" ),
            Output Table( "test" )
      );
      Oneway(
            Y( :Data ),
            X( :Label ),
            Name( "Means/Anova" )(1),
            Means and Std Dev( 1 ),
            Mean Diamonds( 1 ),
            Mean Error Bars( 1 ),
            Std Dev Lines( 1 ),
            Connect Means( 1 ),
            X Axis Proportional( 0 ),
            Points Spread( 1 ),
            Grand Mean( 0 ),
            SendToReport(
            Dispatch(
                  {},
                  "Oneway Plot",
                  FrameBox,
                  {Row Legend(
                        Temp,
                        Color( 1 ),
                        Color Theme( "Blue to Green to Red" ),
                        Marker( 0 ),
                        Marker Theme( "" ),
                        Continuous Scale( 0 ),
                        Reverse Scale( 0 ),
                        Excluded Rows( 0 )
                  )}
                  )
            )
      );
      dt << Stack(
     
      columns(
                  :Ilim__TRIM_TARGET,
                  :Emulate_0000_Ilim_,
                  :Emulate_0001_Ilim_,
                  :Emulate_0010_Ilim_,
                  :_iLIM_BEST_VALUE
            ),
            Source Label Column( "Label" ),
            Stacked Data Column( "Data" ),
            Output Table( "test" )
      );
      Oneway(
            Y( :Data ),
            X( :Label ),
            Name( "Means/Anova" )(1),
            Means and Std Dev( 1 ),
            Mean Diamonds( 1 ),
            Mean Error Bars( 1 ),
            Std Dev Lines( 1 ),
            Connect Means( 1 ),
            X Axis Proportional( 0 ),
            Points Spread( 1 ),
            Grand Mean( 0 ),
            SendToReport(
            Dispatch(
                  {},
                  "Oneway Plot",
                  FrameBox,
                  {Row Legend(
                        Temp,
                        Color( 1 ),
                        Color Theme( "Blue to Green to Red" ),
                        Marker( 0 ),
                        Marker Theme( "" ),
                        Continuous Scale( 0 ),
                        Reverse Scale( 0 ),
                        Excluded Rows( 0 )
                  )}
                  )
            )
      );
);
nw  <<     Set page setup(
    margins( 0.5, 0.5, 0.5, 0.5 ),
    scale( 0.8 ),
    portrait( 0 ),
    paper size( "A3" )
);
jrn = NW << Journal;
NW << save PDF( "C:\My Documents\Trim_CHARTS.pdf" );

 

Thanks

Sam

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

When you create your stacked data tables, simply make them invisible.  They will appear in the JMP Home window, but they will not have a visible window  created.

 dt << Stack(invisible,
      columns(
                  :Ilim__TRIM_TARGET,
                  :Emulate_0000_Ilim_,
                  :Emulate_0001_Ilim_,
                  :Emulate_0010_Ilim_,
                  :_iLIM_BEST_VALUE
            ),
            Source Label Column( "Label" ),
            Stacked Data Column( "Data" ),
            Output Table( "test" )
      );
Jim
SamH

Contributor

Joined:

Mar 3, 2017

Solution

Thanks Jim. it worked.

Appreciated.

3 REPLIES
SamH

Contributor

Joined:

Mar 3, 2017

this is what I end up when the final report/jrn is completed!

jmp.png

txnelson

Super User

Joined:

Jun 22, 2012

Solution

When you create your stacked data tables, simply make them invisible.  They will appear in the JMP Home window, but they will not have a visible window  created.

 dt << Stack(invisible,
      columns(
                  :Ilim__TRIM_TARGET,
                  :Emulate_0000_Ilim_,
                  :Emulate_0001_Ilim_,
                  :Emulate_0010_Ilim_,
                  :_iLIM_BEST_VALUE
            ),
            Source Label Column( "Label" ),
            Stacked Data Column( "Data" ),
            Output Table( "test" )
      );
Jim
SamH

Contributor

Joined:

Mar 3, 2017

Solution

Thanks Jim. it worked.

Appreciated.