315262_en-US

liliconcom

Process screening analysis with variable number of columns

Hello,

 

I am trying to use process screening platform on daily production data from different electrical test operations. My daily data set does contains a lot of columns that need to be analyzed using the process screening platform. Unfortunately, the script fails if I define all possible tests in the code for process screening. The reason behind this is due to the fact that based on production WIP, not all tests are performed in a 24hr period, which leads to change in the number of columns for my daily data pull from the database. 

 

Is there a way I can have a code snippet that will run the process screening platform independent of the number of columns in my dataset without having to define each column name? 

ScriptingRe: Process screening analysis with variable number of columns

Thank you very much this works great. I am guilty of not using the scripting guide enough. I try to search the scripting index most times. 

Re: Process screening analysis with variable number of columns

1. Take the time to read the Scripting Guide from the JMP Documentation Library, found under the Help pull down menu.
2. Here is a sample script

names default to here(1);
dt=open("$SAMPLE_DATA/semiconductor capability.jmp");

// Get all of the columns in the data table
colNamesList = dt << get column names(string, continuous);

// Run process screening
Process Screening( Y( eval(colNamesList) ), Control Chart Type( "Indiv and MR" ) );