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-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ETengo%20una%20tabla%20de%20datos%20con%20un%20par%20de%20cientos%20de%20columnas.%20Me%20gustar%C3%ADa%20poder%20buscar%20en%20todas%20las%20f%C3%B3rmulas%20de%20columna%20para%20ver%20si%20se%20utiliza%20una%20columna%20en%20particular%20en%20alguna%20de%20las%20f%C3%B3rmulas%20de%20columna.%20es%20posible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3ECombinaci%C3%B3n%20y%20limpieza%20de%20datos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ES%C3%AD......%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0A%0Adt%20%3D%20%0A%2F%2F%20Open%20Data%20Table%3A%20Big%20Class.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22Big%20Class%22%20)%0AOpen(%20%22%2FC%3A%2FProgram%20Files%2FJMP%2FJMPPRO%2F19%2FSamples%2FData%2FBig%20Class.jmp%22%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20new%20column(%22Ratio%22%2C%20formula(%3Aheight%2F%3Aweight))%3B%0A%0AtheFormula%20%3D%20Char(dt%3ARatio%20%26lt%3B%26lt%3B%20get%20formula)%3B%0A%0AIf(%20contains(theFormula%2C%20%22height%22)%2C%20show(%22found%20it%22))%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773951%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773951%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3ESi%20tiene%20acceso%20a%20JMP%20Pro%2C%20puede%20hacerlo%20con%20Formula%20Depot.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66308i4153AA45EBEA2641%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_1-1721326886768.png%22%20alt%3D%22jthi_1-1721326886768.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EPuede%20seleccionar%20las%20columnas%20de%20f%C3%B3rmula%2C%20seleccionar%20copiar%20columnas%2C%20abrir%20un%20nuevo%20script%20(ctrl%20%2B%20t)%20y%20pegarlo%20all%C3%AD.%20Luego%20busque%20en%20el%20editor%20de%20scripts.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3ETambi%C3%A9n%20puede%20intentar%20eliminar%20esa%20columna%20y%2C%20si%20se%20est%C3%A1%20utilizando%2C%20JMP%20mostrar%C3%A1%20una%20advertencia%20como%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66307i7EC950140C678ECF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1721326874531.png%22%20alt%3D%22jthi_0-1721326874531.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EEditar%3A%3C%2FP%3E%0A%3CP%3ETambi%C3%A9n%20podr%C3%ADa%20haber%20alguna%20forma%20en%20JMP18%20de%20utilizar%20el%20Administrador%20de%20columnas%2C%20pero%20pude%20encontrar%20una.%20El%20Diccionario%20de%20datos%20casi%20puede%20hacerlo%2C%20pero%20almacena%20las%20f%C3%B3rmulas%20como%20im%C3%A1genes%20para%20que%20no%20se%20puedan%20buscar%20f%C3%A1cilmente.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66309i9AFB3C182B0F0BF4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1721327241713.png%22%20alt%3D%22jthi_0-1721327241713.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EY%2C%20por%20supuesto%2C%20hay%20muchas%20opciones%20de%20secuencias%20de%20comandos%20puras.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJim%2C%3C%2FP%3E%3CP%3EGracias%20por%20esto.%20Dado%20que%20soy%20muy%20pobre%20en%20secuencias%20de%20comandos%20en%20este%20momento%2C%20%C2%BFpodr%C3%ADa%20mostrarme%20c%C3%B3mo%20puedo%20hacer%20que%20su%20algoritmo%20recorra%20todas%20las%20columnas%20de%20una%20tabla%20de%20datos%20y%20genere%20una%20lista%20de%20columnas%20que%20contengan%20el%20valor%20objetivo%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3Ejarmo%2C%3C%2FP%3E%3CP%3ELamentablemente%2C%20no%20tengo%20JMP%20Pro.%20Por%20alguna%20raz%C3%B3n%2C%20el%20mensaje%20de%20error%20que%20recibo%20cuando%20intento%20eliminar%20la%20columna%20no%20enumera%20la%20columna%20que%20contiene%20la%20f%C3%B3rmula.%20No%20s%C3%A9%20por%20qu%C3%A9.%20Tambi%C3%A9n%20pens%C3%A9%20que%20el%20diccionario%20de%20datos%20podr%C3%ADa%20ayudar%2C%20pero%20no%20pude%20ver%20c%C3%B3mo%20una%20vez%20que%20lo%20mir%C3%A9.%20Gracias%20por%20la%20ayuda.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ETambi%C3%A9n%20compart%C3%AD%20una%20opci%C3%B3n%20m%C3%A1s%20que%20no%20depende%20de%20JMP%20Pro.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CEM%3EPuede%20seleccionar%20las%20columnas%20de%20f%C3%B3rmula%2C%20seleccionar%20copiar%20columnas%2C%20abrir%20un%20nuevo%20script%20(ctrl%20%2B%20t)%20y%20pegarlo%20all%C3%AD.%20Luego%20busque%20en%20el%20editor%20de%20scripts.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66310i86ECDCACE3C6E4C3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1721329913297.png%22%20alt%3D%22jthi_0-1721329913297.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66312iF64AC2E7EC7AD827%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_2-1721329951299.png%22%20alt%3D%22jthi_2-1721329951299.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOhhh...%20Eso%20es%20genial.%20No%20sab%C3%ADa%20que%20se%20pod%C3%ADa%20pegar%20una%20columna%20en%20el%20editor%20de%20scripts.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3ECreo%20que%20eso%20funcionar%C3%A1.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%C2%A1Gracias!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EDe%20manera%20similar%20a%20la%20sugerencia%20de%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthi%3C%2FA%3E%20de%20copiar%20el%20script%20de%20cada%20columna%2C%20puede%20copiar%20el%20script%20de%20%3CEM%3Etoda%20la%20tabla%3C%2FEM%3E%20sin%20los%20datos%20usando%20el%20Tri%C3%A1ngulo%20rojo%20(en%20la%20parte%20superior%20izquierda%20de%20la%20tabla)%20%26gt%3B%20Copiar%20script%20de%20tabla%20(sin%20datos).%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66317iD300A27783CE719D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22julian_0-1721339096365.png%22%20alt%3D%22julian_0-1721339096365.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EEl%20script%20contendr%C3%A1%20el%20jsl%20para%20recrear%20su%20tabla%2C%20que%20incluir%C3%A1%20todas%20las%20f%C3%B3rmulas%20de%20sus%20columnas.%20Pegue%20ese%20script%20en%20una%20ventana%20de%20script%20y%20busque%20desde%20all%C3%AD.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%C2%A1Espero%20que%20esto%20ayude!%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40Julian%3C%2FA%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774025%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774025%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40julian%2C%3C%2FA%3E%20%C2%BFtal%20vez%20este%20tipo%20de%20b%C3%BAsquedas%20podr%C3%ADa%20implementarse%20en%20el%20Administrador%20de%20columnas%20de%20alguna%20manera%3F%20Por%20lo%20tanto%2C%20tambi%C3%A9n%20podr%C3%ADamos%20buscar%20los%20valores%20dentro%20de%20Propiedades%20de%20columna%20en%20lugar%20de%20simplemente%20filtrar%20aquellos%20que%20tienen%20propiedades%20espec%C3%ADficas.%20Al%20menos%20F%C3%B3rmula%2C%20Notas%20y%20nombres%20de%20columna%20cortos%2Flargos%20son%20algunas%20de%20las%20propiedades%20de%20las%20columnas%20que%20podr%C3%ADan%20beneficiarse%20si%20pudi%C3%A9ramos%20buscar.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EMe%20gusta%3A%20el%20Administrador%20de%20columnas%20parece%20un%20lugar%20natural%20para%20eso.%20Tambi%C3%A9n%20estaba%20pensando%20en%20c%C3%B3mo%20podr%C3%ADa%20funcionar%20dentro%20del%20cuadro%20de%20di%C3%A1logo%20Buscar%20normal%20si%20hubiera%20otra%20casilla%20de%20verificaci%C3%B3n%20para%20ofrecer%20%22Buscar%20en%20propiedades%20de%20columna%22.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EComenc%C3%A9%20con%20la%20idea%20de%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40julian%3C%2FA%3E%20de%20usar%20el%20script%20de%20tabla%20y%20agregu%C3%A9%20algunas%20funciones%20a%3C%2FP%3E%3CP%3E-%20buscar%20columnas%20en%20las%20f%C3%B3rmulas%20y%3C%2FP%3E%3CP%3E-%20para%20mostrar%20los%20resultados%20de%20la%20b%C3%BAsqueda%3A%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2FOpen(%20%22%24SAMPLE_DATA%2FShip%20Damage.jmp%22%20)%3B%0A%2F%2F%20get%20all%20column%20formulas%20via%20the%20table%20script%20%0Adt%20%3D%20Current%20Data%20Table()%3B%0Adt%20%26lt%3B%26lt%3B%20copy%20table%20script(%20%22No%20Data%22%20)%3B%0Ascript%20%3D%20Parse(%20Get%20Clipboard()%20)%3B%0A%0A%2F%2Fconvert%20to%20List%20for%20easier%20indexing%0ASubstitute%20Into(%20script%2C%20Expr(%20New%20Table()%20)%2C%20Expr(%20%7B%7D%20)%20)%3B%0A%0A%2F%2F%20just%20keep%20the%20columns%0AallCols%20%3D%20Filter%20Each(%20%7Bcol%7D%2C%20script%2C%20Head(%20col%20)%20%3D%3D%20Expr(%20New%20Column()%20)%20)%3B%0A%0A%2F%2F%20convert%20column%20info%20into%20lists%0AColList%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20allCols%2C%20Substitute(%20Name%20Expr(%20col%20)%2C%20Expr(%20New%20Column()%20)%2C%20Expr(%20%7B%7D%20)%20)%20)%3B%0AallColNames%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20ColList%2C%20tmp%20%3D%20Arg(%20col%2C%201%20)%3B%20If%20(is%20string(tmp)%2C%20tmp%2C%20tmp%5B%22en%22%5D)%20)%3B%0A%0A%2F%2F%20keep%20columns%20with%20formulas%0AColsWithFormulas%20%3D%20Filter%20Each(%20%7Bcol%7D%2C%20ColList%2CTry(col%5B%22Formula%22%5D%3B%091%09%2C%090%09))%3B%0A%0AColNames%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20ColsWithFormulas%2C%20tmp%20%3D%20Arg(%20col%2C%201%20)%3B%20If%20(is%20string(tmp)%2C%20tmp%2C%20tmp%5B%22en%22%5D)%20)%3B%0AColFormulas%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20ColsWithFormulas%2C%20col%5B%22Formula%22%5D%20)%3B%0A%0A%2F%2F%20helper%20function%20to%20search%20for%20column%20names%20in%20formulas%0AContainsExpr%20%3D%20Function(%20%7Bexpression%2C%20pattern%7D%2C%0A%09tmp%20%3D%20Substitute(%20Name%20Expr(%20expression%20)%2C%20Name%20Expr(%20pattern%20)%2C%20Expr(%20.%20)%20)%3B%0A%09Not(%20Name%20Expr(%20tmp%20)%20%3D%3D%20Name%20Expr(%20expression%20)%20)%3B%0A)%3B%0A%20%0Asummary%20%3D%20New%20Table(%22Formuala%20Overview%22%2C%0A%09New%20Column(%20%22column%20Formula%22%2C%20Character%20)%2C%0A%09New%20Column(%20%22used%20cols%22%2C%20Character%20)%2C%20%09%0A)%3B%0Await(0)%3B%0A%0A%2F%2F%20fill%20the%20summary%20tale%20with%20all%20combinations%20of%20formulas%20and%20the%20used%20columns%0A%0ACurrent%20Data%20Table(%20dt%20)%3B%20%20%2F%2F%20make%20dt%20the%20current%20data%20table%2C%20otherwise%20%3CAS%20column%3D%22%22%3E%20won't%20work%20!%0AFor%20Each(%20%7BmyFormula%2C%20idx1%7D%2C%20ColFormulas%2C%0A%09For%20Each(%20%7Bcol%7D%2C%20allColNames%2C%0A%09%09formulaCol%20%3D%20ColNames%5Bidx1%5D%3B%0A%09%09dt%3AformulaCol%20%26lt%3B%26lt%3B%20Set%20Header%20Text%20Color(%20%22Red%22%20)%3B%0A%09%09If(%20ContainsExpr(%20Name%20Expr(%20myFormula%20)%2C%20Name%20Expr(%20As%20Column(%20col%20)%20)%20)%2C%0A%09%09%09Eval(%20Eval%20Expr(%20summary%20%26lt%3B%26lt%3B%20add%20row(%20%7B%22column%20Formula%22n%20%3DExpr(formulaCol%20)%2C%20%22used%20cols%22n%20%3D%20Expr(%20col%20)%7D%20)%20)%20)%3B%0A%09%09%09Column(col)%20%26lt%3B%26lt%3B%20Set%20Header%20Background%20Color(%20%7B102%2C%20255%2C%20140%7D%20)%3B%0A%09%09)%0A%09)%0A)%3B%0A%20%0A%2F%2F%20show%20a%20tabulate%20for%20easy%20look%20up%0Asummary%20%26lt%3B%26lt%3B%20Tabulate(%0A%09Show%20Control%20Panel(%200%20)%2C%0A%09Add%20Table(%20Row%20Table(%20Grouping%20Columns(%20%3Acolumn%20Formula%2C%20%3Aused%20cols%20)%20)%20)%2C%0A%09Local%20Data%20Filter(%20Mode(%20Show(%200%20)%20)%2C%20Add%20Filter(%20columns(%20%3Acolumn%20Formula%2C%20%3Aused%20cols%20)%20)%20)%0A)%3B%3C%2FAS%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Eadem%C3%A1s%20del%20enfoque%20para%20resaltar%20la%20columna%20utilizada%20en%20las%20f%C3%B3rmulas%20mediante%20el%20color%20de%20fondo%20de%20la%20columna%2C%3CBR%20%2F%3E%20Se%20podr%C3%ADa%20pensar%20en%20agregar%20un%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FIndicator-Symbol-for-Columns-used-in-Formulas-batch-replace%2Fm-p%2F720399%23U720399%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3Es%C3%ADmbolo%20indicador%20para%20las%20columnas%20utilizadas%20en%20las%20f%C3%B3rmulas.%3C%2FA%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777963%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFPuedes%20buscar%20f%C3%B3rmulas%20de%20columnas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777963%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%40hogi%3C%2FA%3E%20esto%20es%20brillante.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

¿Puedes buscar fórmulas de columnas?

scott1588
Level IV

Tengo una tabla de datos con un par de cientos de columnas. Me gustaría poder buscar en todas las fórmulas de columna para ver si se utiliza una columna en particular en alguna de las fórmulas de columna. es posible?

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

3 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: ¿Puedes buscar fórmulas de columnas?

Sí......

Names Default To Here( 1 );

dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "/C:/Program Files/JMP/JMPPRO/19/Samples/Data/Big Class.jmp" );

dt << new column("Ratio", formula(:height/:weight));

theFormula = Char(dt:Ratio << get formula);

If( contains(theFormula, "height"), show("found it"));
scott1588
Level IV

Re: ¿Puedes buscar fórmulas de columnas?

Ohhh... Eso es genial. No sabía que se podía pegar una columna en el editor de scripts.

Creo que eso funcionará.

¡Gracias!

julian
Community Manager Community Manager

Re: ¿Puedes buscar fórmulas de columnas?

De manera similar a la sugerencia de @jthi de copiar el script de cada columna, puede copiar el script de toda la tabla sin los datos usando el Triángulo rojo (en la parte superior izquierda de la tabla) > Copiar script de tabla (sin datos).

undefined

El script contendrá el jsl para recrear su tabla, que incluirá todas las fórmulas de sus columnas. Pegue ese script en una ventana de script y busque desde allí.

¡Espero que esto ayude!

@Julian

11 REPLIES 11
txnelson
Super User

Re: ¿Puedes buscar fórmulas de columnas?

Sí......

Names Default To Here( 1 );

dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "/C:/Program Files/JMP/JMPPRO/19/Samples/Data/Big Class.jmp" );

dt << new column("Ratio", formula(:height/:weight));

theFormula = Char(dt:Ratio << get formula);

If( contains(theFormula, "height"), show("found it"));

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

scott1588
Level IV

Re: ¿Puedes buscar fórmulas de columnas?

Jim,

Gracias por esto. Dado que soy muy pobre en secuencias de comandos en este momento, ¿podría mostrarme cómo puedo hacer que su algoritmo recorra todas las columnas de una tabla de datos y genere una lista de columnas que contengan el valor objetivo?

jarmo,

Lamentablemente, no tengo JMP Pro. Por alguna razón, el mensaje de error que recibo cuando intento eliminar la columna no enumera la columna que contiene la fórmula. No sé por qué. También pensé que el diccionario de datos podría ayudar, pero no pude ver cómo una vez que lo miré. Gracias por la ayuda.

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

jthi
Super User

Re: ¿Puedes buscar fórmulas de columnas?

También compartí una opción más que no depende de JMP Pro.

Puede seleccionar las columnas de fórmula, seleccionar copiar columnas, abrir un nuevo script (ctrl + t) y pegarlo allí. Luego busque en el editor de scripts.

undefined

undefined

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

scott1588
Level IV

Re: ¿Puedes buscar fórmulas de columnas?

Ohhh... Eso es genial. No sabía que se podía pegar una columna en el editor de scripts.

Creo que eso funcionará.

¡Gracias!

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

jthi
Super User

Re: ¿Puedes buscar fórmulas de columnas?

Si tiene acceso a JMP Pro, puede hacerlo con Formula Depot.

undefined

Puede seleccionar las columnas de fórmula, seleccionar copiar columnas, abrir un nuevo script (ctrl + t) y pegarlo allí. Luego busque en el editor de scripts.

También puede intentar eliminar esa columna y, si se está utilizando, JMP mostrará una advertencia como

undefined

Editar:

También podría haber alguna forma en JMP18 de utilizar el Administrador de columnas, pero pude encontrar una. El Diccionario de datos casi puede hacerlo, pero almacena las fórmulas como imágenes para que no se puedan buscar fácilmente.

undefined

Y, por supuesto, hay muchas opciones de secuencias de comandos puras.

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

julian
Community Manager Community Manager

Re: ¿Puedes buscar fórmulas de columnas?

De manera similar a la sugerencia de @jthi de copiar el script de cada columna, puede copiar el script de toda la tabla sin los datos usando el Triángulo rojo (en la parte superior izquierda de la tabla) > Copiar script de tabla (sin datos).

undefined

El script contendrá el jsl para recrear su tabla, que incluirá todas las fórmulas de sus columnas. Pegue ese script en una ventana de script y busque desde allí.

¡Espero que esto ayude!

@Julian

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

jthi
Super User

Re: ¿Puedes buscar fórmulas de columnas?

@julian, ¿tal vez este tipo de búsquedas podría implementarse en el Administrador de columnas de alguna manera? Por lo tanto, también podríamos buscar los valores dentro de Propiedades de columna en lugar de simplemente filtrar aquellos que tienen propiedades específicas. Al menos Fórmula, Notas y nombres de columna cortos/largos son algunas de las propiedades de las columnas que podrían beneficiarse si pudiéramos buscar.

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

julian
Community Manager Community Manager

Re: ¿Puedes buscar fórmulas de columnas?

Me gusta: el Administrador de columnas parece un lugar natural para eso. También estaba pensando en cómo podría funcionar dentro del cuadro de diálogo Buscar normal si hubiera otra casilla de verificación para ofrecer "Buscar en propiedades de columna".

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).

hogi
Level XII

Re: ¿Puedes buscar fórmulas de columnas?

Comencé con la idea de @julian de usar el script de tabla y agregué algunas funciones a

- buscar columnas en las fórmulas y

- para mostrar los resultados de la búsqueda:

//Open( "$SAMPLE_DATA/Ship Damage.jmp" );
// get all column formulas via the table script 
dt = Current Data Table();
dt << copy table script( "No Data" );
script = Parse( Get Clipboard() );

//convert to List for easier indexing
Substitute Into( script, Expr( New Table() ), Expr( {} ) );

// just keep the columns
allCols = Filter Each( {col}, script, Head( col ) == Expr( New Column() ) );

// convert column info into lists
ColList = Transform Each( {col}, allCols, Substitute( Name Expr( col ), Expr( New Column() ), Expr( {} ) ) );
allColNames = Transform Each( {col}, ColList, tmp = Arg( col, 1 ); If (is string(tmp), tmp, tmp["en"]) );

// keep columns with formulas
ColsWithFormulas = Filter Each( {col}, ColList,Try(col["Formula"];	1	,	0	));

ColNames = Transform Each( {col}, ColsWithFormulas, tmp = Arg( col, 1 ); If (is string(tmp), tmp, tmp["en"]) );
ColFormulas = Transform Each( {col}, ColsWithFormulas, col["Formula"] );

// helper function to search for column names in formulas
ContainsExpr = Function( {expression, pattern},
	tmp = Substitute( Name Expr( expression ), Name Expr( pattern ), Expr( . ) );
	Not( Name Expr( tmp ) == Name Expr( expression ) );
);
 
summary = New Table("Formuala Overview",
	New Column( "column Formula", Character ),
	New Column( "used cols", Character ), 	
);
wait(0);

// fill the summary tale with all combinations of formulas and the used columns

Current Data Table( dt );  // make dt the current data table, otherwise  won't work !
For Each( {myFormula, idx1}, ColFormulas,
	For Each( {col}, allColNames,
		formulaCol = ColNames[idx1];
		dt:formulaCol << Set Header Text Color( "Red" );
		If( ContainsExpr( Name Expr( myFormula ), Name Expr( As Column( col ) ) ),
			Eval( Eval Expr( summary << add row( {"column Formula"n =Expr(formulaCol ), "used cols"n = Expr( col )} ) ) );
			Column(col) << Set Header Background Color( {102, 255, 140} );
		)
	)
);
 
// show a tabulate for easy look up
summary << Tabulate(
	Show Control Panel( 0 ),
	Add Table( Row Table( Grouping Columns( :column Formula, :used cols ) ) ),
	Local Data Filter( Mode( Show( 0 ) ), Add Filter( columns( :column Formula, :used cols ) ) )
);

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).