595976_en-US

liliconcom

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).

Data Blending and CleanupData Exploration and VisualizationRe: Add new quick formula which can be used to compare if selected column values are same in the row - 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. 

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

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 ....

 

 

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

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

unfortunately: 0 Kudos up to now.