Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Highlighted
kaushik_pushpen
Level III

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

  )

)

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
Highlighted
txnelson
Super User

Re: Listcheck function is not working for a array

My last entry failed to have the attachments I indicated.

Jim
Article Labels

    There are no labels assigned to this post.