Listcheck function is not working for a array

kaushik_pushpen

Dear all,

I have two tables in which table 1 consist of  list of parameters and table 2 consist of a complete experiment results with all parameters. Actually, I want to do the tabulate table 2 with the selected parameters given in table 1. Please see my JSL below and correct me where I am wrong. Thanks in advance.

dt1 = open("C:\Users\SCL355-PC\Desktop\ET_PEV\F15320001\F15320001_ET_F1.jmp");   

dt2 = open("C:\Users\SCL355-PC\Desktop\Parameters.jmp");

currentdatatable(dt2);

mylist = :column(dt2, 1)<<getvalues;

currentdatatable(dt1);

column("Parameter")<<listcheck(mylist);

dt1<<Tabulate(

Add Table(

  Column Table(

  Analysis Columns( :Site_Value ),

  Statistics( N, Mean, Std Dev )

  ),

  Row Table( Grouping Columns( :Lot, :Parameter, :Wafer Type ) )

  )

)

txnelson

I  created representative data tables, and then ran your code on them, and had no issue.  I have attached my sample data.  You may want to validate that your dt1 and dt2 data tables are what you want them to be.  It appears that you are stating that you want to Tabulate on data table 2, with the selected parameters given in table 1, however, your code has those tables in the opposite order.