cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.

Add Listagg/Concatenate/GROUP_CONCAT to Summary platform

I would like to have possibility to create column with all values (might cause issues, I know) from Summary platform. This would allow me to calculate statistics for some group and still see values for specific columns. This column could also be made Multiple Response

 

Example with SQL in JMP:

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
Query(
	dt,
	"SELECT age, avg(height), GROUP_CONCAT(name, ',') as name FROM 'Big Class'
    group by age"
);

Would most likely require selection for separator and to determine if column should be multiple response. These could maybe be done in same way as Quantiles which have different selector below column list

jthi_0-1638360999465.png

 

2 Comments
hogi
Level XIII
hogi
Level XIII