cancel
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

Concatenate: column matching

What inspired this wish list request? 

Currently, within the Concatenate function, columns to be concatenated have to have exactly the same header (including case). Frequently, there are small differences or typos which JMP interprets as being a different column. This can be rather frustrating and slows things down.

 

What is the improvement you would like to see? 

The concatenate function to have an extra window where the user can state which columns are matches for each other (I'm thinking it could be something similar to the Group function within Recode)- for each file you're concatenating you could have a list of columns and you could select your columns to match and click a "match" button. If JMP could suggest matches (and show its suggested matches) before producing the new data table that would be useful too (and help catch the odd typo)

 

Why is this idea important? 

 

It smooths out the Concatenate process and saves you time instead of having to change all your column headers to exactly match.

 

1 Comment
hogi
Level XI

hi @Sarah-Sylvestre , I just found 2 more wishes with the same idea:
Concatenate: column matching 

Concatenating table rows with different column names 

Concatenate: option to specify column name match 

 

could you please link the wishes. In total it's now 9 Kudos.