202239_en-US

liliconcom

Scripting Help to move the results from a JMP query to Power point

Hello,

I want to be able to script so that the  output from a query (data table and also the graphs ) should be able to  move to PowerPoint.

The automated script to move output into power point does not work. Thanks for the help.

 

dt = New SQL Query(
 Version( 130 ), 
 Connection(

  "ODBC:DSN=MS_SQL;Description=WAFERVIEWER;Trusted_Connection=Yes;APP=JMP;WSID=USC-28J$#R2;DATABASE=ISL;"

 ), 
 QueryName( "WSSummary" ), 
 Select(
  Column( "CHECK AXOUTPUT", "t1" ),
  Column( "CHECK AYOUTPUT", "t1" ),
  Column( "CHECK AXSELFTEST", "t1" ),
  Column( "CHECK AYSELFTEST", "t1" ),
  Column( "DieID", "t1" ),
  Column( "CMOS_Lot-WaferID", "t1" )
 ), 
 From( Table( "WS_Tests", Alias( "t1" ) ) ), 
 Where(
  In List(
   Column( "CMOS_Lot-WaferID", "t1" ), 
   WaferList, 
   UI( SelectListFilter( ListBox, Base( "Categorical" ) ) )
  )
 )
) << Run Foreground(
 On Run Complete(
  queryResult << Join(
   With( Data Table( "Stacked waferList" ) ), 
   Select(
    :CHECK AXOUTPUT, 
    :CHECK AYOUTPUT, 
    :CHECK AXSELFTEST, 
    :CHECK AYSELFTEST, 
    :DieID
   ), 
   SelectWith( :Label, :Name( "CMOS-Lot-Wafer" ), :Name( "CMOS_Lot-WaferID" ) ), 
   By Matching Columns( :Name( "CMOS_Lot-WaferID" ) = :Name( "CMOS_Lot-WaferID" ) ), 
   Drop multiples( 0, 0 ), 
   Include Nonmatches( 1, 0 ), 
   Preserve main table order( 1 ), 
   Output Table( "OutPut table" ), 
  )
 )
);

dt5 << Close Window;

queryResult << fit = Fit Group(
 Oneway(
  Y(
   :CHECK AXSELFTEST, 
   :CHECK AXOUTPUT, 
   :CHECK AYOUTPUT, 
   :CHECK AYSELFTEST
  ), 
  X( :Label ), 
  All Pairs( 1, LSD Threshold Matrix( 0 ), Confidence Quantile( 0 ), Connecting Letters Report( 1 ) ), 
  t Test( 1 )
 ), 
 <<{Arrange in Rows( 2 )}
);

rfit = fit << report;

rFit << Save Presentation( "$DESKTOP/jmp_example.pptx" );

Open( "$DESKTOP/jmp_example.pptx" );

 

 

 

Re: Scripting Help to move the results from a JMP query to Power point

We'll need some more details about what's going wrong. Simply saying that it doesn't work doesn't give us any clues about where the problem may lie.

 

• Are you receiving any error messages? 
• Have you looked at the log window for any messages?
• Is the PowerPoint file created?

What other details can you provide?