What inspired this wish list request?
Some days ago, I posted here a wish Tables/Update: add aggregation option .
The idea: aggregate the data of the update table before it's merged into the main table.
This could make Tables/Update much faster (!) AND more powerful.
Hm. Actually a user could implement the feature right away if he applies 2 steps:
1) aggregate via Tables/Summary
2) merge via Tables/Update.
But that's not true - because some aggregation options were proposed which are not available yet in Tables/Summary - those for non-numeric values like first/last entry, mode ...
So, if there is something missing in Jmp ...
let's write a wish
(especially as @jthi already proposed to do so: https://community.jmp.com/t5/Discussions/Summarize-Function/m-p/658685/highlight/true#M84794 )
Actuall, in 2019, @ewittry1 posted first version of this wish - to add an aggregation option for character columns in Tables/Summary (via concat):
Summerize/Summary aggregation function for character data. Concat Charcter Vector into a Scalar (by)
Amazingly useful!
Unfortunately, the wish was archived at that time. So, here is a new wish:
What is the improvement you would like to see?
Please add aggregation functions for Character columns
.... to Tables/Summary AND Analyze/Tabulate.
Possible aggregation options are:
- mode (most common entry)
- entry of first matching row
- entry of last matching row
- concatenate the entries of all matching rows (with space, comma, underscore)
- *)
Why is this idea important?
With the current version of Jmp, users can use Summary and Tabulate to ask:
With a future version of Jmp users will be able to ask:
*) I guess there are many more aggregation options for text.
What are the other ones?
