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-826741%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826741%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71826i25F2D784E93F060A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_2-1736536615203.png%22%20alt%3D%22hogi_2-1736536615203.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%2FP%3E%3CP%3E...parece%20que%20esto%20ya%20no%20es%20posible%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71845iE44B4D6E2F66EA1E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1736574848597.png%22%20alt%3D%22hogi_0-1736574848597.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%2FP%3E%3CP%3EProbado%20con%20JMP18.1.1%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EJMP17%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71827i3F73419D43BFF8FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_3-1736536719759.png%22%20alt%3D%22hogi_3-1736536719759.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%2FP%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826741%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EAutomatizaci%C3%B3n%20y%20scripting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826824%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826824%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EParece%20funcionar%20bien%20en%20todas%20las%20versiones%20que%20prob%C3%A9%2C%20incluida%20la%2018.1.1.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71844i78330B944538DAF7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222025-01-10_17-05-01.034.png%22%20alt%3D%222025-01-10_17-05-01.034.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%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826827%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826827%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EEst%C3%A1%20bien.%3CBR%20%2F%3E%3CBR%20%2F%3E%20Y%20algo%20extra%C3%B1o...%3C%2FP%3E%3CP%3EAs%C3%AD%20que%20no%20est%C3%A1%20100%25%20desaparecido%20ni%20tampoco%20funciona%20al%20100%25.%3CBR%20%2F%3E%20%C2%BFQu%C3%A9%20hace%20la%20diferencia%3F%3C%2FP%3E%3CP%3E%C2%BFPC%20versus%20Mac%3F%3CBR%20%2F%3E%20...Comprobar%C3%A9%20mis%20preferencias%20y%20las%20comparar%C3%A9%20con%20m%C3%A1s%20colegas.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826832%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826832%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3ELo%20bueno%3A%3CBR%20%2F%3E%20No%20es%20un%20problema%20general%20de%20%22Lag%22%3CBR%20%2F%3E%3CBR%20%2F%3E%20...parece%20ser%20causado%20por%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71847i7A26B39C512ED097%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_1-1736578008881.png%22%20alt%3D%22hogi_1-1736578008881.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ECuando%20genero%20la%20f%C3%B3rmula%20de%20esta%20manera%2C%20las%20entradas%20est%C3%A1n%20vac%C3%ADas.%3CBR%20%2F%3E%20Cuando%20creo%20una%20nueva%20columna%20y%20luego%20agrego%20la%20f%C3%B3rmula%2C%20se%20calculan%20los%20valores.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3EAgregado%3A%3C%2FSTRONG%3E%20video%20con%20diferentes%20formas%20de%20generar%20la%20columna%20de%20f%C3%B3rmulas.%3C%2FP%3E%3COL%3E%3CLI%3ENueva%20columna%20de%20f%C3%B3rmula%3A%20agregar%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3Eretraso%3C%2FFONT%3E%20mediante%20clic%20-%26gt%3B%20%3CSTRONG%3Efalla%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3ENueva%20columna%20de%20f%C3%B3rmula%3A%20agregar%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3Eretraso%3C%2FFONT%3E%20manualmente%20-%26gt%3B%20%3CSTRONG%3Efalla%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3ENueva%20columna%20de%20f%C3%B3rmula%3A%20eliminar%20c%C3%B3digo%20y%20escribir%20nuevamente%20-%26gt%3B%20%3CSTRONG%3Efalla%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Enueva%20columna%20-%26gt%3B%20agregar%20f%C3%B3rmula%20manualmente%20-%26gt%3B%20funciona%3C%2FLI%3E%3CLI%3ENueva%20columna%20-%26gt%3B%20agregar%20columna%20de%20f%C3%B3rmula%20mediante%20clic%20y%20escritura%20(como%20n.%C2%B0%202)%20-%26gt%3B%20funciona%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-vid-container%20video-embed-center%22%3E%3CDIV%20id%3D%22lia-vid-6366947406112w770h540r158%22%20class%3D%22lia-video-brightcove-player-container%22%3E%3CVIDEO-JS%20data-video-id%3D%226366947406112%22%20data-account%3D%226058004218001%22%20data-player%3D%22default%22%20data-embed%3D%22default%22%20class%3D%22vjs-fluid%22%20controls%3D%22%22%20data-application-id%3D%22%22%20style%3D%22width%3A%20100%25%3B%20height%3A%20100%25%3B%22%3E%3C%2FVIDEO-JS%3E%3C%2FDIV%3E%3CSCRIPT%20src%3D%22https%3A%2F%2Fplayers.brightcove.net%2F6058004218001%2Fdefault_default%2Findex.min.js%22%3E%3C%2FSCRIPT%3E%3CA%20class%3D%22video-embed-link%22%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fvideo%2Fgallerypage%2Fvideo-id%2F6366947406112%22%20target%3D%22_blank%22%3E(ver%20en%20Mis%20Videos)%3C%2FA%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826833%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826833%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EEnvi%C3%A9%20un%20ticket%20al%20soporte%20de%20JMP%3A%20TS-00182750%3CBR%20%2F%3E%20vamos%20a%20ver%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826834%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826834%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EParece%20que%20JMP%20evaluar%C3%A1%20incorrectamente%20el%20argumento%20%22faltante%22%20en%20Empty()%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20Transform%20column%0AData%20Table(%22Big%20Class%22)%20%26lt%3B%26lt%3B%20Apply%20Formula(%0A%09Columns(%3Aweight)%2C%0A%09Formula(Lag(%3Aweight%2C%20Empty()))%2C%0A%09Output(New%20Formula)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ESi%20usa%20Lag%20en%20Fila%2C%20esto%20no%20sucede%20porque%20utiliza%20otro%20m%C3%A9todo%20para%20crear%20la%20columna.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20New%20formula%20column%3A%20Lag%5Bweight%5D%0AData%20Table(%22Big%20Class%22)%20%26lt%3B%26lt%3B%20New%20Formula%20Column(%0A%09Operation(Category(%22Row%22)%2C%20%22Lag%22)%2C%0A%09Columns(%3Aweight)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CBR%20%2F%3E%0A%3CP%3EEditar%3A%20Y%20sucede%20con%20otras%20funciones%20tambi%C3%A9n%20(al%20menos%20con%20Dif%20pero%20podr%C3%ADa%20haber%20otras)%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20Transform%20column%0AData%20Table(%22Big%20Class%22)%20%26lt%3B%26lt%3B%20Apply%20Formula(%0A%09Columns(%3Aweight)%2C%0A%09Formula(Dif(%3Aweight%2C%20Empty()))%2C%0A%09Output(New%20Formula)%0A)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826836%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20%C2%BFUtilizas%20lag(x)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826836%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EBuen%20punto%2C%20gracias%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%20por%20profundizar.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ENunca%20prest%C3%A9%20atenci%C3%B3n%20y%20not%C3%A9%20las%202%20formas%20en%20que%20el%20editor%20de%20f%C3%B3rmulas%20muestra%20argumentos%20opcionales%3A%3C%2FP%3E%3COL%3E%3CLI%3Eexpl%C3%ADcito%3A%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_1-1736585128111.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736585128111.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736585128111.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71850iAFEAB20DAA52F1A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_1-1736585128111.png%22%20alt%3D%22hogi_1-1736585128111.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Eno%20%5Bs%C3%B3lo%20en%20la%20descripci%C3%B3n%5D%3A%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1736585047899.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736585047899.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736585047899.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71849iBA2E0F5F1DAEE79D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1736585047899.png%22%20alt%3D%22hogi_0-1736585047899.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
hogi
Level XII

Do you use lag(x)?

hogi_2-1736536615203.png

... seems that this is no longer possible: 

hogi_0-1736574848597.png

tested with JMP18.1.1

 

JMP17:

hogi_3-1736536719759.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
hogi
Level XII

Re: Do you use lag(x)?

The good thing:
It's not a general issue of "Lag"

... it seems to be caused by:

hogi_1-1736578008881.png

 

When I generate the Formula this way, the entries are empty.
When I create a new column and add the formula afterwards, the values are calculated.

 

added: video with different ways to generate the formula column

  1. new formula column: add lag via click      -> fail
  2. new formula column: add lag manually    ->  fail
  3. new formula column: delete code and write again    -> fail
  4. new column -> add formula manually -> works
  5. new column -> add formula column via click and write (like #2) -> works

 

 

View solution in original post

jthi
Super User

Re: Do you use lag(x)?

Seems like JMP will incorrectly evaluate the "missing" argument to Empty()

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Lag(:weight, Empty())),
	Output(New Formula)
);

If you use Lag under Row this doesn't happen as it uses other method to create the column

// New formula column: Lag[weight]
Data Table("Big Class") << New Formula Column(
	Operation(Category("Row"), "Lag"),
	Columns(:weight)
);

 

Edit: And it does happen with other functions too (at least with Dif but there could be other)

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Dif(:weight, Empty())),
	Output(New Formula)
);
-Jarmo

View solution in original post

6 REPLIES 6
Jeff_Perkinson
Community Manager Community Manager

Re: Do you use lag(x)?

Seems to work fine in all the versions I tried, including 18.1.1.

2025-01-10_17-05-01.034.png

-Jeff
hogi
Level XII

Re: Do you use lag(x)?

Ok, good.

And kind of strange ...

So, it's neither 100% gone - nor 100% working.
what makes the difference ?

PC vs. Mac?
... I will check my preferences - and compare with more colleagues.

hogi
Level XII

Re: Do you use lag(x)?

The good thing:
It's not a general issue of "Lag"

... it seems to be caused by:

hogi_1-1736578008881.png

 

When I generate the Formula this way, the entries are empty.
When I create a new column and add the formula afterwards, the values are calculated.

 

added: video with different ways to generate the formula column

  1. new formula column: add lag via click      -> fail
  2. new formula column: add lag manually    ->  fail
  3. new formula column: delete code and write again    -> fail
  4. new column -> add formula manually -> works
  5. new column -> add formula column via click and write (like #2) -> works

 

 

hogi
Level XII

Re: Do you use lag(x)?

I submitted a ticket to JMP support: TS-00182750
let's see ...

jthi
Super User

Re: Do you use lag(x)?

Seems like JMP will incorrectly evaluate the "missing" argument to Empty()

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Lag(:weight, Empty())),
	Output(New Formula)
);

If you use Lag under Row this doesn't happen as it uses other method to create the column

// New formula column: Lag[weight]
Data Table("Big Class") << New Formula Column(
	Operation(Category("Row"), "Lag"),
	Columns(:weight)
);

 

Edit: And it does happen with other functions too (at least with Dif but there could be other)

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Dif(:weight, Empty())),
	Output(New Formula)
);
-Jarmo
hogi
Level XII

Re: Do you use lag(x)?

Good point, thanks @jthi for digging deeper.

 

I never paid attention and noticed the 2 ways formula editor displays optional arguments:

  1. explicit:
    hogi_1-1736585128111.png

  2. not [just in the description]:
    hogi_0-1736585047899.png