cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EAjoutez%20une%20nouvelle%20formule%20rapide%20qui%20peut%20%C3%AAtre%20utilis%C3%A9e%20pour%20comparer%20si%20les%20valeurs%20de%20colonne%20s%C3%A9lectionn%C3%A9es%20sont%20les%20m%C3%AAmes%20dans%20la%20ligne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EDe%20temps%20en%20temps%2C%20je%20rencontre%20une%20situation%20dans%20laquelle%20j'aimerais%20v%C3%A9rifier%20rapidement%20si%20deux%20colonnes%20ont%20exactement%20les%20m%C3%AAmes%20r%C3%A9sultats%20en%20lignes.%20Je%20fais%20habituellement%20cela%20en%20%C3%A9crivant%20une%20nouvelle%20colonne%20avec%20%3ACOL1%20%3D%3D%20COL2%20par%20exemple.%20Ce%20serait%20bien%20d'avoir%20cela%20comme%20option%20Nouvelle%20formule%20dans%20le%20menu%20contextuel%20(et%2C%20esp%C3%A9rons-le%2C%20de%20prendre%20en%20charge%20plus%20de%202%20colonnes).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EM%C3%A9lange%20et%20nettoyage%20des%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExploration%20et%20visualisation%20des%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-598803%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%26nbsp%3B%3A%20Ajouter%20une%20nouvelle%20formule%20rapide%20qui%20peut%20%C3%AAtre%20utilis%C3%A9e%20pour%20comparer%20si%20les%20valeurs%20de%20colonne%20s%C3%A9lectionn%C3%A9es%20sont%20identiques%20dans%20la%20ligne%20-%20Statut%20chang%C3%A9%20en%26nbsp%3B%3A%26nbsp%3BReconnu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-598803%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESalut%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%20%40jthi%3C%2FA%3E%20%2C%20merci%20d'avoir%20pris%20le%20temps%20de%20soumettre%20cette%20id%C3%A9e%20!%20Nous%20examinerons%20votre%20demande%20et%20vous%20tiendrons%20au%20courant%20de%20son%20statut.%3CSPAN%20class%3D%22Apple-converted-space%22%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778617%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Ajouter%20une%20nouvelle%20formule%20rapide%20qui%20peut%20%C3%AAtre%20utilis%C3%A9e%20pour%20comparer%20si%20les%20valeurs%20des%20colonnes%20s%C3%A9lectionn%C3%A9es%20sont%20les%20m%C3%AAmes%20dans%20la%20ligne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778617%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EJ'ai%20souvent%20le%20m%C3%AAme%20probl%C3%A8me%20et%20cette%20fonctionnalit%C3%A9%20me%20manque.%3C%2FP%3E%3CP%3EMais%20il%20semble%20que%20nous%20soyons%20tous%20les%20deux%20les%20seuls%20%C3%A0%20comparer%20%22r%C3%A9guli%C3%A8rement%22%20les%20valeurs%20dans%20diff%C3%A9rentes%20colonnes%20-%20et%20%C3%A0%20vouloir%20faciliter%20cette%20d%C3%A9marche.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EComme%20d'autres%20souhaits%20d'am%C3%A9lioration%20du%20nouveau%20menu%20de%20colonnes%20de%20formules%20ont%20%C3%A9t%C3%A9%20rejet%C3%A9s%20(les%20d%C3%A9veloppeurs%20veulent%20garder%20le%20menu%20%22mince%22)%2C%20je%20crains%20que%20celui-ci%20ne%20trouve%20pas%20non%20plus%20son%20chemin%20dans%20JMP.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EN%C3%A9anmoins%2C%20avec%20la%20nouvelle%20entr%C3%A9e%20%3CSTRONG%3ENouvelle%20colonne%20de%20formule%2FFormule...%2C%3C%2FSTRONG%3E%20il%20est%20devenu%20beaucoup%20plus%20facile%20de%20cr%C3%A9er%20manuellement%20une%20telle%20colonne%20de%20formule%26nbsp%3B%3A%3C%2FP%3E%3CP%3Eutiliser%20la%20nouvelle%20entr%C3%A9e%3C%2FP%3E%3CP%3E...%20ajoutez%20%3D%20et%20la%20deuxi%C3%A8me%20colonne.%20fait.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EHum....%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20358px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20358px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722635827650.png%22%20style%3D%22width%3A%20358px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66788iECACAA653681EF10%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1722635827650.png%22%20alt%3D%22hogi_0-1722635827650.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778626%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Ajouter%20une%20nouvelle%20formule%20rapide%20qui%20peut%20%C3%AAtre%20utilis%C3%A9e%20pour%20comparer%20si%20les%20valeurs%20des%20colonnes%20s%C3%A9lectionn%C3%A9es%20sont%20les%20m%C3%AAmes%20dans%20la%20ligne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778626%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EAh%2C%20j'ai%20m%C3%AAme%20soumis%20un%20souhait%20%3A%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2Fnew-formula-column-equals%2Fm-p%2F657291%23U657291%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%3Enouvelle%20colonne%20de%20formule%26nbsp%3B%3A%26nbsp%3B%C3%A9gal%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20malheureusement%26nbsp%3B%3A%200%20f%C3%A9licitations%20jusqu'%C3%A0%20pr%C3%A9sent.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Add new quick formula which can be used to compare if selected column values are same in the row

From time to time I come across situation where I would like to quickly check if two columns have exactly same results in rows. I usually do this by writing new column with :COL1 == COL2 for example. It would be nice to have this as an New Formula option in right click menu (and hopefully support more than 2 columns).

3 Comments
Status changed to: Acknowledged

Hi @jthi, thank you for taking the time to submit this idea! We will review your request and keep you updated on its status. 

hogi
Level XII

I often have the same issue - and miss this functionality.

But seems that the both of us are the only ones who "regularly" compare values in different columns - and have the wish to facilitate the step.

 

As other wishes to improve the new formula column menu got rejected (developers want to keep the menu "slim") , I fear that this one won't find it's way into JMP either.

 

Nevertheless, with the new New Formula column/Formula ... entry it got significantly easier to create such a formula column manually:

use the new entry

... add = and the second column. done.

 

Hm ....

 

hogi_0-1722635827650.png

 

hogi
Level XII

Ah, I even submitted a wish:
new formula column: equals 

unfortunately: 0 Kudos up to now.