Accepted Solutions
I think it is my pc that is the problem. Your script looks like it should work and works on your pc. i downloaded your sample tables but on my machine it gives an error/Alert. It looks as your solution works but something else is happening. I think i need to fix the I/O first before im able to implement your solution.
Hi Txnelson,
I try to use your script to run import my limit file but occur error. (attach my limit spec file)
it looks long variable name or character '/' issue, could you help? Thank you.
Regards,Chily
This is fairly old script (and post) and depending on what you are trying to do in the end defines how to modify it (or maybe you should use other script completely or possibly the add-in provided).
With the add-in you will have to change Variable columns modeling type from Unstructured Text to Nominal
Below is one fairly quick modification which should work if you have JMP16+ for the script (modifications done to lines 24 and 26):
Names Default To Here( 1 );
// Select the data table and open it
path = Pick File( "Select Data Table" );
dt = Open( path );
// Select the limits table and open it
path = Pick File( "Select Limits Table" );
dt2 = Open( path );
// Point to the data table as the main table
Current Data Table( dt );
// Open a new window to select the process variables
nw = New Window( "Select Process Variables",
Text Box( "Selection Columns" ),
H List Box(
datacolbox = Col List Box( all ),
Button Box( "Process Variables", pList << append( datacolbox << get selected ) ),
pList = List Box( {} )
),
Button Box( "OK",
thelist = plist << get items;
pvars = ":\!"" || thelist[1] ||"\!"n";
For( i = 2, i <= N Items( thelist ), i++,
pvars = pvars || ", :\!"" || thelist[i] ||"\!"n";
);
Eval(
Parse(
"obj = dt << Process Capability(
Process Variables(" || pvars || " ),
Spec Limits( Import Spec Limits( dt2 ) )
);"
)
);
nw << close window;
)
);