cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar

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

Status: Acknowledged Submitted by Super User on ‎02-01-2023 11:17 AM
3 Comments (3 New)

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
Sarah-Sylvestre
Staff
Staff
‎02-08-2023 04:33 PM
‎02-08-2023 04:33 PM
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 XI
Friday
Friday

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 XI
Friday
Friday

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

unfortunately: 0 Kudos up to now.