cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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?

Recommended Articles