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

make NewFormulaColumn/Character more flexible

Status: Investigating Submitted by on ‎09-12-2022 11:09 AM
5 Comments (5 New)

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

 

 

If columns with type "character" are selected, the New Formula Column menu shows the submenu character.
Among other option, there is the function concatenate which concatenates the strings.

There are also 2 more functions. They concatenate with Space or comma.

 

My wish:

  • A more general function "concatenate with string ...".
    The idea: After selecting this function, a window pops up and asks the user to enter a string.
    Then one can concatenate also with "_" or "-" or ...

 

Contrary to what I wrote in a previous version of this post, "concatenate" is also available if characters AND numbers are selected.
If numbers are selected as well, a char(number) is added automatically. Cool
Unfortunately, the character/concatenate function is missing if all the selected columns are numbers.
Could you please make the concatenate function available also for this variant?

 

 

HolgerSp_0-1662993965694.png

 

more wishes submitted by  hogi_2-1702196401638.png

5 Comments
Sarah-Sylvestre
Staff
Staff
‎09-21-2022 04:53 PM
‎09-21-2022 04:53 PM
Status changed to: Acknowledged

@hogi - Thank you for your suggestion! We have captured your request and will take it under consideration.

hogi
Level XI
‎09-25-2022 12:08 PM
‎09-25-2022 12:08 PM

A workaraound can be found at: Col/Utilities/Combine Columns.

 

Most of the features are exactly matching:

- the user can specify the delimiter character

- the result column can be set  "multiple response"

- the function is also avalilable if all selected columns are "numbers"

 

The only disadvantage:
It generates the new colum by writing the values - i.e. not as a function.

Therefore, the table canot be used as a template and adding new data via tables/concatenate will not work.

 

 

HolgerSp_0-1664121535761.png

 

hogi
Level XI
‎10-26-2022 01:54 PM
‎10-26-2022 01:54 PM

new in JMP 17: concatenate with underscore  -> thanks

exactly the option that I wanted

hogi_0-1666806575061.png

 

backlog:

Unfortunately, the character/concatenate function is missing if all the selected columns are numbers.
Could you please make the character/concatenate functions available also if just numbers are selected?

 

Sarah-Sylvestre
Staff
Staff
‎12-15-2022 02:16 PM
‎12-15-2022 02:16 PM
Status changed to: Investigating
 
jthi
Super User
Super User
‎12-17-2022 04:32 PM
‎12-17-2022 04:32 PM

Wish List item which was marked as Duplicate due to this wish list item which is a bit more wide in scope: Enable string concatenation in "New Formula Column" -> "Combine" for numerical columns