make NewFormulaColumn/Character more flexible☐ 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?
more wishes submitted by 
Data Blending and CleanupRe: make NewFormulaColumn/Character more flexibleWish 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
Re: make NewFormulaColumn/Character more flexible - Status changed to: InvestigatingRe: make NewFormulaColumn/Character more flexiblenew in JMP 17: concatenate with underscore -> thanks
exactly the option that I wanted
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?
Re: make NewFormulaColumn/Character more flexibleA 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.
Re: make NewFormulaColumn/Character more flexible - Status changed to: Acknowledged@hogi - Thank you for your suggestion! We have captured your request and will take it under consideration.
Re: make NewFormulaColumn/Character more flexible@Sarah-Sylvestre , status of this wish can be set to delivered.
The part which is still open is covered by Enable string concatenation in "New Formula Column" -> "Combine" for numerical columns
Re: make NewFormulaColumn/Character more flexible - Status changed to: Delivered
