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%3E%C2%BFSe%20pueden%20sobrescribir%20las%20columnas%20Pasa%2FFalla%20cuando%20se%20actualizan%20nuevos%20l%C3%ADmites%20de%20especificaciones%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729696%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EEn%20una%20tabla%20de%20datos%2C%20%C2%BFse%20pueden%20sobrescribir%20las%20columnas%20Pasa%2FFalla%20cuando%20se%20actualizan%20nuevos%20l%C3%ADmites%20de%20especificaciones%3F%3C%2FP%3E%3CP%3ENecesito%20sobrescribir%20%22P%22%20o%20%22F%22%20para%20cada%20fila...%20en%20cada%20columna%20Pasa%2FFalla%20(asociada%20con%20cada%20prueba).%3C%2FP%3E%3CP%3ESi%20alguien%20tiene%20un%20script%20jsl%20para%20esto...%20ser%C3%ADa%20perfecto%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%3ERe%3A%20%C2%BFSe%20pueden%20sobrescribir%20las%20columnas%20Pasado%2FReprobado%20cuando%20se%20actualizan%20nuevos%20l%C3%ADmites%20de%20especificaci%C3%B3n%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739285%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHay%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55529%22%20target%3D%22_blank%22%3E%40cmobrien15%3C%2FA%3E%20%2C%3C%2FP%3E%0A%3CP%3ECreo%20que%20se%20puede%20hacer%20a%20trav%C3%A9s%20de%20JSL%20siempre%20que%20Pasa%2FNo%20pasa%20sea%20una%20columna%20de%20f%C3%B3rmula.%3C%2FP%3E%0A%3CP%3ELos%20pasos%20ser%C3%ADan%3B%3C%2FP%3E%0A%3CP%3E1.%20Conjunto%20de%20datos%20existente%20con%20l%C3%ADmite%20de%20especificaci%C3%B3n%20existente%20y%20columnas%20de%20f%C3%B3rmula%20de%20aprobaci%C3%B3n%2Fdesaprobaci%C3%B3n%20existentes%3C%2FP%3E%0A%3CP%3E2.%20Reemplace%20el%20l%C3%ADmite%20de%20especificaci%C3%B3n%20con%20el%20nuevo%20l%C3%ADmite%3C%2FP%3E%0A%3CP%3E3.%20Se%20actualiz%C3%B3%20la%20columna%20de%20f%C3%B3rmula%20de%20aprobaci%C3%B3n%2Freprobaci%C3%B3n%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3ESi%20puede%20completar%20los%20pasos%20anteriores%20manualmente%2C%20puede%20consultar%20los%20scripts%20JSL%20en%20el%20generador%20de%20flujo%20de%20trabajo%20o%20en%20el%20registro.%3C%2FP%3E%0A%3CP%3ESin%20embargo%2C%20no%20estoy%20seguro%20de%20cu%C3%A1ntas%20columnas%20de%20aprobado%2Freprobado%20tienes.%3C%2FP%3E%0A%3CP%3ELa%20columna%20Pasado%2FReprobado%20se%20basa%20en%20condiciones%20que%3B%3C%2FP%3E%0A%3CP%3E-%20Si%20alguna%20de%20las%20pruebas%20falla%2C%20%C2%BFse%20considera%20un%20fracaso%3F%20%C2%BFO%20deben%20fallar%20todas%20las%20pruebas%20para%20considerarse%20un%20fracaso%3F%3C%2FP%3E%0A%3CP%3E-%20%C2%BFColumna%20de%20aprobado%2Freprobado%20para%20cada%20prueba%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?