Hello Everyone,
I am pulling my spec limits from a data table that is and they have a few issues I have noticed with my data:
Case 1. the LSL and the Target are the same number
Case 2. The Target and the USL are the same number
Case 3: If LSL and Target are Zero (0)
is there a JSL solution to get rid of these issues?
What I want:
Case 1: Remove the Target if LSL is the same
Case 2: Remove the Target if the USL is the same
Case 3: Remove the LSL if Target is Zero (0)
This is an example of what I have.
This is what I would like to have
I have not had any luck trying to get this to work with the JMP Scripting Index.
Any help would be much appreciated.
Thanks,
-Ryan
This is fairly simple to script. Below is an example script which should handle the case1 (take note that order does matter with these):
Names Default To Here(1);
dt = New Table("Specs",
Add Rows(5),
New Column("Column 1",
Character,
"Nominal",
Set Values({"Part 1", "Part 2", "Part 3", "Part 4", "Part 5"})
),
New Column("LSL", Numeric, "Continuous", Format("Best", 12), Set Values([0, 38, 93, 9, 9])),
New Column("TARGET", Numeric, "Continuous", Format("Best", 12), Set Values([0, 40, 94, 10, 9])),
New Column("USL",
Numeric,
"Continuous",
Format("Best", 12),
Set Values([13, 41, 94, 10, 10])
)
);
//ORDER MATTERS WITH THESE (see case1 vs case3)
//case 1<BR />wait(2); //to help with visualization on what is going on
curRows = dt << Get Rows Where(:LSL == :Target);
:Target[curRows] = .;
//case 2
//case 3You can use << Get Rows Where(condition) to get the rows you want to modify in a matrix and then use that matrix with data table subscripting to update values.
