Subscribe Bookmark RSS Feed

Listcheck function is not working for a array

kaushik_pushpen

Community Trekker

Joined:

Feb 22, 2015

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

  )

)

2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

Joined:

Jun 22, 2012

My last entry failed to have the attachments I indicated.

Jim