spec limits jsl script

Salil — Sat, 01 Jul 2017 00:37:23 GMT

Hi,

I tried to write a jsl script for reading in spec limits from a table to columns in another data table, based on discussions in this community. Pasted below is the script, and the corresponding data and spec limits tables are attached.

I am not sure what I am doing wrong, but when I check the column properties of the data table after running the script, the Spec Limits fields are still blank. Can someone please let me know what I am doing wrong? Thanks in advance.

Names Default To Here( 1 );

dt = Open("test1.jmp");

dt1 = Open("test1_spec.csv");

dt << current data table ();

x = dt << Get Column Names(string);
y = dt1 << Get Column Names(string);

ncols = N Items (x);

for (i=1, i<=ncols, i++,
	v = Column(i) << Get Name;
	z = (Loc(y,v)) [1];
	dt1 << current data table();
	uLimit = Column(z)[1];	
	lLimit = Column(z)[2];
	tLimit = Column(z)[3];
	dt << current data table ();
	Eval(
		Eval Expr(
		Column(dt,char(x[i])) << Set Property(
			"Spec Limits",
			{LSL( Expr( lLimit ) ), USL( Expr( uLimit ) ), Target( Expr( tLimit ) ),
			Show Limits( 1 )}
		)
	)
)
);

test_spec (spec limits table):

Description	a	c	d
USL	11	25	42
LSL	0	1	2.5
TT	5	11	23

test1 (data table):

a	b	c	d
1	3	2	4
2	6	4	8
3	9	6	12
4	12	8	16
5	15	10	20
6	18	12	24
7	21	14	28
8	24	16	32
9	27	18	36
10	30	20	40

Re: spec limits jsl script

txnelson — Sat, 01 Jul 2017 02:37:11 GMT

Take a look at the File Exchange Addin called

Write Limits to a Data Table from a Limits Table. The assumed format of the input limits data table is different than your specified structure, however, you could easily either change your structure, or modify the JSL from the addin

a	b	c	d
1	3	2	4
2	6	4	8
3	9	6	12
4	12	8	16
5	15	10	20
6	18	12	24
7	21	14	28
8	24	16	32
9	27	18	36
10	30	20	40

a	b	c	d
1	3	2	4
2	6	4	8
3	9	6	12
4	12	8	16
5	15	10	20
6	18	12	24
7	21	14	28
8	24	16	32
9	27	18	36
10	30	20	40

topic spec limits jsl script in Discussions

spec limits jsl script

Re: spec limits jsl script

Write Limits to a Data Table from a Limits Table. The assumed format of the input limits data table is different than your specified structure, however, you could easily either change your structure, or modify the JSL from the addin

a	b	c	d
1	3	2	4
2	6	4	8
3	9	6	12
4	12	8	16
5	15	10	20
6	18	12	24
7	21	14	28
8	24	16	32
9	27	18	36
10	30	20	40