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
%3CLINGO-SUB%20id%3D%22lingo-sub-729696%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ELe%20colonne%20Pass%2FFail%20possono%20essere%20sovrascritte%20quando%20vengono%20aggiornati%20i%20nuovi%20limiti%20delle%20specifiche%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729696%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIn%20una%20tabella%20dati%2C%20le%20colonne%20Pass%2FFail%20possono%20essere%20sovrascritte%20quando%20vengono%20aggiornati%20i%20nuovi%20limiti%20delle%20specifiche%3F%3C%2FP%3E%3CP%3E%C3%88%20necessario%20che%20%22P%22%20o%20%22F%22%20vengano%20sovrascritti%20per%20ogni%20riga...%20in%20ciascuna%20colonna%20Superato%2FFallito%20(associata%20a%20ciascun%20test).%3C%2FP%3E%3CP%3ESe%20qualcuno%20avesse%20uno%20script%20jsl%20per%20questo%2C....%20sarebbe%20perfetto%20%26gt%3B%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-739285%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ER%3A%20Le%20colonne%20Pass%2FFail%20possono%20essere%20sovrascritte%20quando%20vengono%20aggiornati%20i%20nuovi%20limiti%20delle%20specifiche%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739285%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ECiao%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55529%22%20target%3D%22_blank%22%3E%40cmbrien15%3C%2FA%3E%20%2C%3C%2FP%3E%0A%3CP%3EPenso%20che%20sia%20possibile%20farlo%20tramite%20JSL%2C%20a%20patto%20che%20la%20colonna%20Pass%2FFail%20sia%20una%20formula.%3C%2FP%3E%0A%3CP%3EI%20passaggi%20sarebbero%3B%3C%2FP%3E%0A%3CP%3E1.%20Set%20di%20dati%20esistente%20con%20limite%20di%20specifiche%20esistente%20e%20colonne%20di%20formula%20pass%2Ffail%20esistenti%3C%2FP%3E%0A%3CP%3E2.%20Sostituisci%20il%20limite%20di%20specifica%20con%20il%20nuovo%20limite%3C%2FP%3E%0A%3CP%3E3.%20Aggiornata%20la%20colonna%20della%20formula%20Pass%2FFail%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3ESe%20%C3%A8%20possibile%20completare%20manualmente%20i%20passaggi%20precedenti%2C%20%C3%A8%20possibile%20fare%20riferimento%20agli%20script%20JSL%20nel%20generatore%20di%20flussi%20di%20lavoro%20o%20nel%20registro.%3C%2FP%3E%0A%3CP%3ETuttavia%2C%20non%20sono%20sicuro%20di%20quante%20colonne%20hai%20superato%2Fnon%20superato.%3C%2FP%3E%0A%3CP%3ELa%20colonna%20Superato%2FNon%20superato%20si%20basa%20sulle%20condizioni%20che%3B%3C%2FP%3E%0A%3CP%3E-%20Se%20uno%20qualsiasi%20dei%20test%20fallisce%2C%20viene%20considerato%20fallito%3F%20Oppure%20tutti%20i%20test%20devono%20fallire%20per%20essere%20considerati%20falliti%3F%3C%2FP%3E%0A%3CP%3E-%20Colonna%20Superato%2FNon%20superato%20per%20ogni%20test%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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?