I regularly work with Cpk reports which include SPC/FAI dimensions and spec limits. To analyze the distributions I import the data and spec limits into JMP and graph the distributions using the Analyze - Quality & Process - Capability function.
Sometimes, though, there are SPC dimensions that are not measured and these cells are left blank. But when I want to save the spec limits to the data table, JMP doesn't allow me because those cells are empty.
I want to write a script that has an 'if else' statement that parses through all the FAI/SPC columns and detects whether the cells are populated are not.
There are two windows (spec limits, data). I would like to know how to activate one window over the other. How do I do this? And in the case this is not necessary, I would still like to learn because I would like to automate the process of importing and analyzing my Cpk reports, which requires activating one window over the other anyway.