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%3EPouvez-vous%20rechercher%20des%20formules%20de%20colonnes%26nbsp%3B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJ'ai%20un%20tableau%20de%20donn%C3%A9es%20avec%20quelques%20centaines%20de%20colonnes.%20J'aimerais%20pouvoir%20rechercher%20dans%20toutes%20les%20formules%20de%20colonnes%20pour%20voir%20si%20une%20colonne%20particuli%C3%A8re%20est%20utilis%C3%A9e%20dans%20l'une%20des%20formules%20de%20colonnes.%20Est-ce%20possible%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%3EM%C3%A9lange%20et%20nettoyage%20des%20donn%C3%A9es%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOui......%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%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%20vous%20avez%20acc%C3%A8s%20%C3%A0%20JMP%20Pro%2C%20vous%20pouvez%20le%20faire%20avec%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%3EVous%20pouvez%20s%C3%A9lectionner%20les%20colonnes%20de%20formule%2C%20s%C3%A9lectionner%20les%20colonnes%20de%20copie%2C%20ouvrir%20un%20nouveau%20script%20(ctrl%20%2B%20t)%20et%20y%20coller.%20Recherchez%20ensuite%20dans%20l'%C3%A9diteur%20de%20script.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EVous%20pouvez%20%C3%A9galement%20essayer%20de%20supprimer%20cette%20colonne%20et%20si%20elle%20est%20utilis%C3%A9e%2C%20JMP%20affichera%20un%20avertissement%20comme%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%3EModifier%3A%3C%2FP%3E%0A%3CP%3EIl%20pourrait%20%C3%A9galement%20y%20avoir%20un%20moyen%20d'utiliser%20le%20gestionnaire%20de%20colonnes%20dans%20JMP18%2C%20mais%20je%20pourrais%20en%20trouver%20un.%20Le%20dictionnaire%20de%20donn%C3%A9es%20peut%20presque%20le%20faire%2C%20mais%20il%20stocke%20les%20formules%20sous%20forme%20d'images%20afin%20qu'elles%20ne%20puissent%20pas%20%C3%AAtre%20recherch%C3%A9es%20facilement.%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%3EEt%20bien%20s%C3%BBr%2C%20il%20existe%20de%20nombreuses%20options%20de%20script%20pur%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%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%3EMerci%20pour%20cela.%20%C3%89tant%20donn%C3%A9%20que%20je%20suis%20vraiment%20mauvais%20en%20mati%C3%A8re%20de%20scripts%20%C3%A0%20ce%20stade%2C%20pourriez-vous%20me%20montrer%20comment%20faire%20en%20sorte%20que%20votre%20algorithme%20parcoure%20toutes%20les%20colonnes%20d'une%20table%20de%20donn%C3%A9es%20et%20g%C3%A9n%C3%A8re%20une%20liste%20de%20colonnes%20contenant%20la%20valeur%20cible%26nbsp%3B%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJarmo%2C%3C%2FP%3E%3CP%3EMalheureusement%2C%20je%20n'ai%20pas%20JMP%20Pro.%20Pour%20une%20raison%20quelconque%2C%20le%20message%20d'erreur%20que%20je%20re%C3%A7ois%20lorsque%20j'essaie%20de%20supprimer%20la%20colonne%20ne%20r%C3%A9pertorie%20pas%20la%20colonne%20contenant%20la%20formule.%20Je%20ne%20sais%20pas%20pourquoi.%20J'ai%20%C3%A9galement%20pens%C3%A9%20que%20le%20dictionnaire%20de%20donn%C3%A9es%20pourrait%20peut-%C3%AAtre%20aider%2C%20mais%20je%20ne%20voyais%20pas%20comment%20une%20fois%20que%20je%20l'avais%20regard%C3%A9.%20Merci%20pour%20l'aide%20cependant.%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJ'ai%20%C3%A9galement%20partag%C3%A9%20une%20option%20suppl%C3%A9mentaire%20qui%20ne%20d%C3%A9pend%20pas%20de%20JMP%20Pro%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CEM%3EVous%20pouvez%20s%C3%A9lectionner%20les%20colonnes%20de%20formule%2C%20s%C3%A9lectionner%20les%20colonnes%20de%20copie%2C%20ouvrir%20un%20nouveau%20script%20(ctrl%20%2B%20t)%20et%20y%20coller.%20Recherchez%20ensuite%20dans%20l'%C3%A9diteur%20de%20script.%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%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...%20C'est%20cool.%20Je%20ne%20savais%20pas%20qu'on%20pouvait%20coller%20une%20colonne%20dans%20l'%C3%A9diteur%20de%20script.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJe%20pense%20que%20cela%20fonctionnera.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EMerci!%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ESemblable%20%C3%A0%20la%20suggestion%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%20copier%20le%20script%20de%20chaque%20colonne%2C%20vous%20pouvez%20copier%20le%20script%20de%20la%20%3CEM%3Etable%20enti%C3%A8re%3C%2FEM%3E%20sans%20les%20donn%C3%A9es%20en%20utilisant%20le%20triangle%20rouge%20(en%20haut%20%C3%A0%20gauche%20de%20la%20table)%20%26gt%3B%20Copier%20le%20script%20de%20la%20table%20(pas%20de%20donn%C3%A9es).%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%3ELe%20script%20contiendra%20le%20jsl%20pour%20recr%C3%A9er%20votre%20table%2C%20qui%20inclura%20toutes%20vos%20formules%20de%20colonnes.%20Collez%20ce%20script%20dans%20une%20fen%C3%AAtre%20de%20script%20et%20effectuez%20une%20recherche%20%C3%A0%20partir%20de%20l%C3%A0.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EJ'esp%C3%A8re%20que%20%C3%A7a%20aide!%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%40julien%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%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%3C%2FA%3E%20peut-%C3%AAtre%20que%20ce%20type%20de%20recherche%20pourrait%20%C3%AAtre%20impl%C3%A9ment%C3%A9%20dans%20Column%20Manager%20dans%20une%20certaine%20mesure%20%3F%20Nous%20pourrions%20donc%20%C3%A9galement%20rechercher%20les%20valeurs%20dans%20les%20propri%C3%A9t%C3%A9s%20de%20colonne%20au%20lieu%20de%20simplement%20filtrer%20celles%20qui%20ont%20des%20propri%C3%A9t%C3%A9s%20sp%C3%A9cifiques.%20Au%20moins%2C%20les%20noms%20de%20colonnes%20Formule%2C%20Notes%20et%20Court%2FLong%20sont%20quelques%20propri%C3%A9t%C3%A9s%20de%20colonne%20qui%20pourraient%20%C3%A9ventuellement%20b%C3%A9n%C3%A9ficier%20d'une%20recherche.%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EJ%E2%80%99aime%20%C3%A7a%20%E2%80%93%20Columns%20Manager%20semble%20%C3%AAtre%20un%20endroit%20naturel%20pour%20cela.%20Je%20pensais%20%C3%A9galement%20%C3%A0%20la%20fa%C3%A7on%20dont%20cela%20pourrait%20fonctionner%20dans%20la%20bo%C3%AEte%20de%20dialogue%20Rechercher%20ordinaire%20s'il%20y%20avait%20une%20autre%20case%20%C3%A0%20cocher%20pour%20proposer%20%C2%AB%26nbsp%3BRechercher%20dans%20les%20propri%C3%A9t%C3%A9s%20de%20la%20colonne%26nbsp%3B%C2%BB.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EJ'ai%20commenc%C3%A9%20avec%20l'id%C3%A9e%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%20d'utiliser%20le%20script%20de%20table%20et%20j'ai%20ajout%C3%A9%20quelques%20fonctions%20%C3%A0%3C%2FP%3E%3CP%3E-%20rechercher%20des%20colonnes%20dans%20les%20formules%20et%3C%2FP%3E%3CP%3E-%20pour%20afficher%20les%20r%C3%A9sultats%20de%20la%20recherche%20%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Eoutre%20l'approche%20permettant%20de%20mettre%20en%20%C3%A9vidence%20la%20colonne%20utilis%C3%A9e%20dans%20les%20formules%20via%20la%20couleur%20d'arri%C3%A8re-plan%20de%20la%20colonne%2C%3CBR%20%2F%3E%20on%20pourrait%20penser%20%C3%A0%20ajouter%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%3Esymbole%20indicateur%20pour%20les%20colonnes%20utilis%C3%A9es%20dans%20les%20formules%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%20%3A%20Pouvez-vous%20rechercher%20des%20formules%20de%20colonnes%20%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%20c'est%20g%C3%A9nial.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

Pouvez-vous rechercher des formules de colonnes ?

scott1588
Level IV

J'ai un tableau de données avec quelques centaines de colonnes. J'aimerais pouvoir rechercher dans toutes les formules de colonnes pour voir si une colonne particulière est utilisée dans l'une des formules de colonnes. Est-ce possible?

Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

11 REPLIES 11
hogi
Level XII

Re : Pouvez-vous rechercher des formules de colonnes ?

outre l'approche permettant de mettre en évidence la colonne utilisée dans les formules via la couleur d'arrière-plan de la colonne,
on pourrait penser à ajouter un symbole indicateur pour les colonnes utilisées dans les formules

Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

julian
Community Manager Community Manager

Re : Pouvez-vous rechercher des formules de colonnes ?

@hogi c'est génial.

Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).