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%3EK%C3%B6nnen%20Sie%20Spaltenformeln%20durchsuchen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIch%20habe%20eine%20Datentabelle%20mit%20mehreren%20hundert%20Spalten.%20Ich%20m%C3%B6chte%20alle%20Spaltenformeln%20durchsuchen%20k%C3%B6nnen%2C%20um%20zu%20sehen%2C%20ob%20eine%20bestimmte%20Spalte%20in%20einer%20der%20Spaltenformeln%20verwendet%20wird.%20Ist%20das%20m%C3%B6glich%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%3EDatenzusammenf%C3%BChrung%20und%20-bereinigung%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%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJa......%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%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773951%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EWenn%20Sie%20Zugriff%20auf%20JMP%20Pro%20haben%2C%20k%C3%B6nnen%20Sie%20dies%20mit%20Formula%20Depot%20tun.%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%3ESie%20k%C3%B6nnen%20die%20Formelspalten%20ausw%C3%A4hlen%2C%20Spalten%20kopieren%20ausw%C3%A4hlen%2C%20ein%20neues%20Skript%20%C3%B6ffnen%20(Strg%20%2B%20T)%20und%20dort%20einf%C3%BCgen.%20Suchen%20Sie%20dann%20im%20Skripteditor.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3ESie%20k%C3%B6nnen%20auch%20versuchen%2C%20diese%20Spalte%20zu%20entfernen.%20Wenn%20sie%20verwendet%20wird%2C%20zeigt%20JMP%20eine%20Warnung%20wie%20diese%20an.%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%3EBearbeiten%3A%3C%2FP%3E%0A%3CP%3EEs%20k%C3%B6nnte%20auch%20eine%20M%C3%B6glichkeit%20in%20JMP18%20geben%2C%20den%20Columns%20Manager%20zu%20verwenden%2C%20aber%20ich%20k%C3%B6nnte%20mir%20eine%20ausdenken.%20Data%20Dictionary%20kann%20das%20fast%2C%20aber%20es%20speichert%20die%20Formeln%20als%20Bilder%2C%20sodass%20sie%20nicht%20einfach%20durchsucht%20werden%20k%C3%B6nnen%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%3EUnd%20nat%C3%BCrlich%20gibt%20es%20jede%20Menge%20reine%20Scripting-Optionen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%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%3EDanke%20daf%C3%BCr.%20Da%20ich%20im%20Scripting%20derzeit%20wirklich%20schlecht%20bin%2C%20k%C3%B6nnten%20Sie%20mir%20zeigen%2C%20wie%20ich%20Ihren%20Algorithmus%20alle%20Spalten%20einer%20Datentabelle%20durchlaufen%20lassen%20und%20eine%20Liste%20der%20Spalten%20ausgeben%20kann%2C%20die%20den%20Zielwert%20enthalten%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJarmo%2C%3C%2FP%3E%3CP%3ELeider%20habe%20ich%20kein%20JMP%20Pro.%20Aus%20irgendeinem%20Grund%20wird%20in%20der%20Fehlermeldung%2C%20die%20ich%20beim%20Versuch%2C%20die%20Spalte%20zu%20l%C3%B6schen%2C%20erhalte%2C%20die%20Spalte%20mit%20der%20Formel%20nicht%20aufgef%C3%BChrt.%20Ich%20wei%C3%9F%20nicht%2C%20warum.%20Ich%20dachte%20auch%2C%20dass%20das%20Datenw%C3%B6rterbuch%20helfen%20k%C3%B6nnte%2C%20aber%20als%20ich%20es%20mir%20angeschaut%20habe%2C%20konnte%20ich%20nicht%20erkennen%2C%20wie.%20Trotzdem%20danke%20f%C3%BCr%20die%20Hilfe.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIch%20habe%20auch%20eine%20weitere%20Option%20geteilt%2C%20die%20nicht%20von%20JMP%20Pro%20abh%C3%A4ngig%20ist%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CEM%3ESie%20k%C3%B6nnen%20die%20Formelspalten%20ausw%C3%A4hlen%2C%20Spalten%20kopieren%20ausw%C3%A4hlen%2C%20ein%20neues%20Skript%20%C3%B6ffnen%20(Strg%20%2B%20T)%20und%20dort%20einf%C3%BCgen.%20Suchen%20Sie%20dann%20im%20Skripteditor.%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%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOhhhh%20...%20Das%20ist%20cool.%20Ich%20wusste%20nicht%2C%20dass%20man%20eine%20Spalte%20in%20den%20Skripteditor%20einf%C3%BCgen%20kann.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EIch%20denke%2C%20das%20wird%20funktionieren.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EDanke!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%C3%84hnlich%20wie%20bei%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthis%3C%2FA%3E%20Vorschlag%2C%20das%20Skript%20jeder%20Spalte%20zu%20kopieren%2C%20k%C3%B6nnen%20Sie%20das%20Skript%20der%20%3CEM%3Egesamten%20Tabelle%3C%2FEM%3E%20ohne%20die%20Daten%20kopieren%2C%20indem%20Sie%20auf%20das%20rote%20Dreieck%20(oben%20links%20in%20der%20Tabelle)%20%26gt%3B%20Tabellenskript%20kopieren%20(keine%20Daten)%20klicken.%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%3EDas%20Skript%20enth%C3%A4lt%20das%20JSL%20zum%20Neuerstellen%20Ihrer%20Tabelle%2C%20das%20alle%20Ihre%20Spaltenformeln%20enth%C3%A4lt.%20F%C3%BCgen%20Sie%20das%20Skript%20in%20ein%20Skriptfenster%20ein%20und%20starten%20Sie%20die%20Suche%20von%20dort%20aus.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EIch%20hoffe%20das%20hilft!%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%40julianisch%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%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%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%20vielleicht%20k%C3%B6nnte%20diese%20Art%20der%20Suche%20in%20irgendeiner%20Form%20in%20den%20Spaltenmanager%20implementiert%20werden%3F%20So%20k%C3%B6nnten%20wir%20auch%20nach%20den%20Werten%20in%20den%20Spalteneigenschaften%20suchen%2C%20anstatt%20nur%20nach%20denen%20mit%20bestimmten%20Eigenschaften%20zu%20filtern.%20Zumindest%20Formel%2C%20Notizen%20und%20kurze%2Flange%20Spaltennamen%20sind%20einige%20Spalteneigenschaften%2C%20bei%20denen%20es%20m%C3%B6glicherweise%20von%20Vorteil%20w%C3%A4re%2C%20wenn%20wir%20danach%20suchen%20k%C3%B6nnten.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EMir%20gef%C3%A4llt%20es%20%E2%80%93%20der%20Spalten-Manager%20scheint%20daf%C3%BCr%20der%20nat%C3%BCrliche%20Ort%20zu%20sein.%20Ich%20habe%20auch%20dar%C3%BCber%20nachgedacht%2C%20wie%20es%20im%20normalen%20Suchdialog%20funktionieren%20k%C3%B6nnte%2C%20wenn%20es%20ein%20weiteres%20Kontrollk%C3%A4stchen%20g%C3%A4be%2C%20um%20%E2%80%9EIn%20Spalteneigenschaften%20suchen%E2%80%9C%20anzubieten.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EIch%20habe%20mit%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40julians%3C%2FA%3E%20Idee%20angefangen%2C%20das%20Tabellenskript%20zu%20verwenden%20und%20einige%20Funktionen%20hinzugef%C3%BCgt%2C%20um%3C%2FP%3E%3CP%3E-%20Suche%20nach%20Spalten%20in%20den%20Formeln%20und%3C%2FP%3E%3CP%3E-%20um%20die%20Suchergebnisse%20anzuzeigen%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%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Eneben%20dem%20Ansatz%2C%20in%20Formeln%20verwendete%20Spalten%20%C3%BCber%20die%20Spaltenhintergrundfarbe%20hervorzuheben%2C%3CBR%20%2F%3E%20Man%20k%C3%B6nnte%20dar%C3%BCber%20nachdenken%2C%20ein%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%3EIndikatorsymbol%20f%C3%BCr%20Spalten%20hinzuzuf%C3%BCgen%2C%20die%20in%20Formeln%20verwendet%20werden%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%3EBetreff%3A%20K%C3%B6nnen%20Spaltenformeln%20durchsucht%20werden%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%2C%3C%2FA%3E%20das%20ist%20brillant.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

Können Sie Spaltenformeln durchsuchen?

scott1588
Level IV

Ich habe eine Datentabelle mit mehreren hundert Spalten. Ich möchte alle Spaltenformeln durchsuchen können, um zu sehen, ob eine bestimmte Spalte in einer der Spaltenformeln verwendet wird. Ist das möglich?

Dieser Beitrag wurde ursprünglich in English (US) geschrieben und wurde zu Ihrer Bequemlichkeit übersetzt. Wenn Sie antworten, wird es auch in English (US) übersetzt.

11 REPLIES 11
hogi
Level XII

Betreff: Können Spaltenformeln durchsucht werden?

neben dem Ansatz, in Formeln verwendete Spalten über die Spaltenhintergrundfarbe hervorzuheben,
Man könnte darüber nachdenken, ein Indikatorsymbol für Spalten hinzuzufügen, die in Formeln verwendet werden

Dieser Beitrag wurde ursprünglich in English (US) geschrieben und wurde zu Ihrer Bequemlichkeit übersetzt. Wenn Sie antworten, wird es auch in English (US) übersetzt.

julian
Community Manager Community Manager

Betreff: Können Spaltenformeln durchsucht werden?

@hogi, das ist brillant.

Dieser Beitrag wurde ursprünglich in English (US) geschrieben und wurde zu Ihrer Bequemlichkeit übersetzt. Wenn Sie antworten, wird es auch in English (US) übersetzt.