JMP Script: Setting spec Limits from variable
Hi,
I am a newbie who is writing a simple JMP script to clean up a raw data table. A part of my script reads in the Spec Limits and data range from a reference table. It then applies these limits and ranges to the raw data table.
For some reason JMP doesnot apply the spec limits to the columns. When I open the column info to look for spec limits, there are no numbers in the spec limit field.
The range checks seems to be fine though. Also, I can set the Spec Limits when I use hard coded numbers.
Here are code segments and log file excerpts
---------------------------------------------------------------------------------------------
lslval = eval(dtlim:LSLNum);
show(lslval);
uslval = dtlim:USLNum;
targetval = dtlim:targetNum;
lowrangeval = dtlim:lowrange;
highrangeval = dtlim:highrange;
CurrentDataTable(dt);
col = column name(i);
col << range check(LTLT(lowrangeval, highrangeval));
col< limits = col< show(col,limits , lowrangeval, highrangeval);
------------------------------------------------------------------
Log file excerpt
----------------------------------------------------------------
lslval:0.578
col::Test# 51
limits:{LSL(Eval(lslval)), USL(2), Target(1)}
lowrangeval:0
highrangeval:21
