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%3EVerwenden%20Sie%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...%20scheint%2C%20dass%20dies%20nicht%20mehr%20m%C3%B6glich%20ist%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%3Egetestet%20mit%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%3EAutomatisierung%20und%20Skripting%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%3EBetreff%3A%20Verwenden%20Sie%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%3EScheint%20in%20allen%20Versionen%2C%20die%20ich%20ausprobiert%20habe%2C%20einwandfrei%20zu%20funktionieren%2C%20einschlie%C3%9Flich%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%3EBetreff%3A%20Verwenden%20Sie%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%3EOkay%20gut.%3CBR%20%2F%3E%3CBR%20%2F%3E%20Und%20irgendwie%20seltsam%20...%3C%2FP%3E%3CP%3EEs%20ist%20also%20weder%20zu%20100%26nbsp%3B%25%20verschwunden%2C%20noch%20funktioniert%20es%20zu%20100%26nbsp%3B%25.%3CBR%20%2F%3E%20was%20macht%20den%20Unterschied%3F%3C%2FP%3E%3CP%3EPC%20oder%20Mac%3F%3CBR%20%2F%3E%20...%20werde%20ich%20meine%20Pr%C3%A4ferenzen%20pr%C3%BCfen%20%E2%80%93%20und%20mit%20weiteren%20Kollegen%20vergleichen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826832%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EBetreff%3A%20Verwenden%20Sie%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%3EDas%20Gute%3A%3CBR%20%2F%3E%20Es%20ist%20kein%20allgemeines%20Problem%20von%20%22Lag%22%3CBR%20%2F%3E%3CBR%20%2F%3E%20...%20die%20Ursache%20scheint%20zu%20sein%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%3EWenn%20ich%20die%20Formel%20auf%20diese%20Weise%20erstelle%2C%20sind%20die%20Eintr%C3%A4ge%20leer.%3CBR%20%2F%3E%20Wenn%20ich%20eine%20neue%20Spalte%20erstelle%20und%20anschlie%C3%9Fend%20die%20Formel%20hinzuf%C3%BCge%2C%20werden%20die%20Werte%20berechnet.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3Ehinzugef%C3%BCgt%3A%3C%2FSTRONG%3E%20Video%20mit%20verschiedenen%20M%C3%B6glichkeiten%20zum%20Generieren%20der%20Formelspalte%3C%2FP%3E%3COL%3E%3CLI%3Eneue%20Formelspalte%3A%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3EVerz%C3%B6gerung%3C%2FFONT%3E%20per%20Klick%20hinzuf%C3%BCgen%20-%26gt%3B%20%3CSTRONG%3EFehlschlag%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Eneue%20Formelspalte%3A%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3EVerz%C3%B6gerung%3C%2FFONT%3E%20manuell%20hinzuf%C3%BCgen%20-%26gt%3B%20%3CSTRONG%3Efehlgeschlagen%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Eneue%20Formelspalte%3A%20Code%20l%C3%B6schen%20und%20erneut%20schreiben%20-%26gt%3B%20%3CSTRONG%3Efehlgeschlagen%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Eneue%20Spalte%20-%26gt%3B%20Formel%20manuell%20hinzuf%C3%BCgen%20-%26gt%3B%20funktioniert%3C%2FLI%3E%3CLI%3Eneue%20Spalte%20-%26gt%3B%20Formelspalte%20per%20Klick%20und%20Schreiben%20hinzuf%C3%BCgen%20(wie%20%232)%20-%26gt%3B%20funktioniert%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(in%20%E2%80%9EMeine%20Videos%E2%80%9C%20anzeigen)%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%3EBetreff%3A%20Verwenden%20Sie%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%3EIch%20habe%20ein%20Ticket%20an%20den%20JMP-Support%20gesendet%3A%20TS-00182750%3CBR%20%2F%3E%20mal%20sehen%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%3EBetreff%3A%20Verwenden%20Sie%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%3EScheint%20so%2C%20als%20w%C3%BCrde%20JMP%20das%20%E2%80%9Efehlende%E2%80%9C%20Argument%20f%C3%BCr%20Empty()%20falsch%20auswerten.%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%3EWenn%20Sie%20Lag%20unter%20Zeile%20verwenden%2C%20geschieht%20dies%20nicht%2C%20da%20eine%20andere%20Methode%20zum%20Erstellen%20der%20Spalte%20verwendet%20wird%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%3EBearbeiten%3A%20Und%20es%20passiert%20auch%20mit%20anderen%20Funktionen%20(zumindest%20mit%20Dif%2C%20aber%20es%20k%C3%B6nnte%20auch%20andere%20geben)%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%3EBetreff%3A%20Verwenden%20Sie%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%3EGuter%20Punkt%2C%20danke%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%20f%C3%BCrs%20tiefere%20Graben.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EIch%20habe%20nie%20darauf%20geachtet%20und%20die%20zwei%20M%C3%B6glichkeiten%20bemerkt%2C%20wie%20der%20Formeleditor%20optionale%20Argumente%20anzeigt%3A%3C%2FP%3E%3COL%3E%3CLI%3Eexplizit%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%3Enicht%20%5Bnur%20in%20der%20Beschreibung%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