cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • See how to interactively organize and restructure data for analysis. Register for May 29 webinar, 2pm US ET.

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