How to add a single Fail column when any one or more test parameter fail (spec limits saved to each parameter column)?

[#1]

I have a data table with test data. The first column has the part ID and rest of the columns (other column names are test parameter names) having test data corresponding to each part ID. All tested parameters columns have spec limits (LSL/USL) saved in them. I want to add a Fail column (with 1 for fail otherwise 0) when any one or more of the test parameters for each part fail the spec (LSL or USL or both).

How to do this in JSL?

(my data set is very similar to $SAMPLE_DATA\Semiconductor Capability.jmp)

[#2]

With JSL you could try using Select Out of Spec Values with Process Capability

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Cities.jmp");
obj = dt << Process Capability(
	Process Variables(:OZONE, :CO, :SO2, :NO),
	Spec Limits(Import Spec Limits("$SAMPLE_DATA/CitySpecLimits.jmp"))
);
obj << Select Out of Spec Values(1);

And then set 1 to those rows which have been selected and then clear selection (and close platform)

[#3]

@jthi . Thanks. If you provide your example using $SAMPLE_DATA\Semiconductor Capability.jmp  instead, it would help me understand the necessary steps better as the is table is very similar to what I already have i.e. spec limits already applied to the columns.I do not need to import spec limits like in the Cities data table. 

[#4]

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
col_names = dt << Get Column Names("String");
Remove From(col_names, 1, 4);
pc = dt << Process Capability(
	Process Variables(Eval(col_names)),
);
pc << Select Out of Spec Values(1);

[#5]

@jthi . This should work, but my data table has got some parameters without spec limits which need to be ignored. I can do this manually, but can this be done automatically?

[#6]

You could loop over the list of your parameter list and then filter out those which don't have spec limits defined. Then use that cleaned list as input for Process Capability

[#7]

Thanks @jthi . I notice that in Process Capability there is an option of skipping columns without spec limits. Saving the script from the interactive dialog box shows  but I cannot find this in the scripting index. 

Spec Limits Dialog( "No (skip columns with no spec limits)" ),

Is there a JSL command for the same?

[#8 · Accepted solution]

If JMP can create it to your script, you can most likely use it even if it is not mentioned in Script Index

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
col_names = dt << Get Column Names("String");
Remove From(col_names, 1, 4);
pc = dt << Process Capability(
	Process Variables(Eval(col_names)),
	Spec Limits Dialog("No (skip columns with no spec limits)"),
);
pc << Select Out of Spec Values(1);