202239_zh-TW

liliconcom

腳本幫助將結果從JMP查詢移動到Power Point

你好，

我希望能夠編寫腳本以便輸出一個詢問 （數據表和圖表）應該能夠移動到PowerPoint。

將輸出移動到電源點的自動腳本不起作用。謝謝您的幫助。

 

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：腳本幫助將結果從JMP查詢移動到Power point

我們需要更多關於出了什麼問題的細節。簡單地說它不起作用並沒有給我們任何關於問題可能存在的線索。

 

• 您收到任何錯誤消息嗎？ 
• 您是否查看了日誌窗口中的任何消息？
• 是否創建了PowerPoint文件？

您還可以提供哪些其他細節？