Hi,
Past user of jmp but new to scripting. I'm looking to make my life easier and automatically create control charts from a folder containing upto 55 csv files, save an image of the control chart using the name of the csv and record the LCL, AVG and UCL from each control chart in a separate data table (an added bonus would be to automatically calculate the cpk and ppk from the data) and save in a folder of my choice, then close all data tables and control charts all from the script.
Currently I have the following (as I said I'm new to scipting) but using the multiple file import script and a loop I can open each data table and create control charts, I'm just not sure how to achieve the rest of my request. Any help would be most appreciated.
Clear Log();
Multiple File Import(
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<) << Import Data;
Names Default To Here( 1 );
dtList = {};
For( i = 1, i <= N Table(), i++,
dt = data table(i);
insert into(dtList, dt );
dtList[i] <Show Capability( 1 ),
Variables( Y( :Value ) ),
Chart( Position( 1 ), Limits( Sigma( "Moving Range" ) ) ),
Chart( Position( 2 ), Limits( Sigma( "Moving Range" ) ) )
);
);
Awesome, worked like a charm.
I now need to change it as I now need to access the files through a server, pick the individual file and interrogate it that way. The data for each measurement connected to one SPC measurement is now is one column so I have to apply filters to the column to separate the data. Any help would be most appreciated.
Here's an example script using some JMP sample data:
tables = Multiple File Import(
<<SET folder=""></SET>
