Choose Language Hide Translation Bar
kaushik_pushpen
Community Trekker

Listcheck function is not working for a array

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 ) )

  )

)

0 Kudos
2 REPLIES 2
Highlighted
txnelson
Super User

Re: Listcheck function is not working for a array

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.

Jim
txnelson
Super User

Re: Listcheck function is not working for a array

My last entry failed to have the attachments I indicated.

Jim