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%3EAdd%20new%20quick%20formula%20which%20can%20be%20used%20to%20compare%20if%20selected%20column%20values%20are%20same%20in%20the%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-595976%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EFrom%20time%20to%20time%20I%20come%20across%20situation%20where%20I%20would%20like%20to%20quickly%20check%20if%20two%20columns%20have%20exactly%20same%20results%20in%20rows.%20I%20usually%20do%20this%20by%20writing%20new%20column%20with%20%3ACOL1%20%3D%3D%20COL2%20for%20example.%20It%20would%20be%20nice%20to%20have%20this%20as%20an%20New%20Formula%20option%20in%20right%20click%20menu%20(and%20hopefully%20support%20more%20than%202%20columns).%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%3EData%20Blending%20and%20Cleanup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Exploration%20and%20Visualization%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%3A%20Add%20new%20quick%20formula%20which%20can%20be%20used%20to%20compare%20if%20selected%20column%20values%20are%20same%20in%20the%20row%20-%20Status%20changed%20to%3A%20Acknowledged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-598803%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHi%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%2C%20thank%20you%20for%20taking%20the%20time%20to%20submit%20this%20idea!%20We%20will%20review%20your%20request%20and%20keep%20you%20updated%20on%20its%20status.%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%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%3A%20Add%20new%20quick%20formula%20which%20can%20be%20used%20to%20compare%20if%20selected%20column%20values%20are%20same%20in%20the%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778617%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EI%20often%20have%20the%20same%20issue%20-%20and%20miss%20this%20functionality.%3C%2FP%3E%3CP%3EBut%20seems%20that%20the%20both%20of%20us%20are%20the%20only%20ones%20who%20%22regularly%22%20compare%20values%20in%20different%20columns%20-%20and%20have%20the%20wish%20to%20facilitate%20the%20step.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20other%20wishes%20to%20improve%20the%20new%20formula%20column%20menu%20got%20rejected%20(developers%20want%20to%20keep%20the%20menu%20%22slim%22)%20%2C%20I%20fear%20that%20this%20one%20won't%20find%20it's%20way%20into%20JMP%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENevertheless%2C%20with%20the%20new%3CSTRONG%3E%20New%20Formula%20column%2FFormula%20...%3C%2FSTRONG%3E%20entry%20it%20got%20significantly%20easier%20to%20create%20such%20a%20formula%20column%20manually%3A%3C%2FP%3E%3CP%3Euse%20the%20new%20entry%3C%2FP%3E%3CP%3E...%20add%20%3D%20and%20the%20second%20column.%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHm%20....%3C%2FP%3E%3CP%3E%26nbsp%3B%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%26nbsp%3B%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%3A%20Add%20new%20quick%20formula%20which%20can%20be%20used%20to%20compare%20if%20selected%20column%20values%20are%20same%20in%20the%20row%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%20I%20even%20submitted%20a%20wish%3A%3CBR%20%2F%3E%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%3Enew%20formula%20column%3A%20equals%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3Eunfortunately%3A%200%20Kudos%20up%20to%20now.%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.