cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
cmobrien15
Level I

Can the Pass/Fail columns be overwritten when new spec limits are updated?

In a data-table,  can the Pass/Fail columns be overwritten when new spec limits are updated?

I need "P" or "F" to be overwritten  for every row.....in each Pass / Fail column (associated with each test).

If someone has a jsl script for this,.... that would be perfect >

 

1 REPLY 1
WebDesignesCrow
Super User

Re: Can the Pass/Fail columns be overwritten when new spec limits are updated?

Hi @cmobrien15 ,

I think it is do able through JSL as long as the Pass/Fail is a formula column.

Steps would be;

1. Existing dataset with existing spec limit & existing pass/fail formula columns

2. Replace the spec limit with new limit

3. Pass/Fail formula column updated

 

If can complete above steps manually, you can refer the JSL scripts in the workflow builder or log.

However, I'm not sure how many pass/fail columns that you have.

The Pass/Fail column is based on conditions that;

- If any of test fail considered fail? or must fail every test to be considered fail?

- Pass/Fail column for each test?