cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-441070%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EListagg%2FConcatenate%2FGROUP_CONCAT%20%E3%82%92%20Summary%20%E3%83%97%E3%83%A9%E3%83%83%E3%83%88%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%81%AB%E8%BF%BD%E5%8A%A0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-441070%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E6%A6%82%E8%A6%81%E3%83%97%E3%83%A9%E3%83%83%E3%83%88%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%81%8B%E3%82%89%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%80%A4%E3%82%92%E5%90%AB%E3%82%80%E5%88%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%A7%E3%81%8D%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E8%80%83%E3%81%88%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%EF%BC%88%E5%95%8F%E9%A1%8C%E3%81%8C%E7%99%BA%E7%94%9F%E3%81%99%E3%82%8B%E5%8F%AF%E8%83%BD%E6%80%A7%E3%81%8C%E3%81%82%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AF%E3%82%8F%E3%81%8B%E3%81%A3%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%EF%BC%89%E3%80%82%E3%81%93%E3%82%8C%E3%81%AB%E3%82%88%E3%82%8A%E3%80%81%E3%81%82%E3%82%8B%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E3%81%AE%E7%B5%B1%E8%A8%88%E3%82%92%E8%A8%88%E7%AE%97%E3%81%97%E3%81%AA%E3%81%8C%E3%82%89%E3%80%81%E7%89%B9%E5%AE%9A%E3%81%AE%E5%88%97%E3%81%AE%E5%80%A4%E3%82%92%E7%A2%BA%E8%AA%8D%E3%81%A7%E3%81%8D%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%81%AE%E5%88%97%E3%81%AF%E8%A4%87%E6%95%B0%E5%9B%9E%E7%AD%94%E3%81%AB%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%82%82%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EJMP%20%E3%81%A7%E3%81%AE%20SQL%20%E3%81%AE%E4%BE%8B%3A%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0AQuery(%0A%09dt%2C%0A%09%22SELECT%20age%2C%20avg(height)%2C%20GROUP_CONCAT(name%2C%20'%2C')%20as%20name%20FROM%20'Big%20Class'%0A%20%20%20%20group%20by%20age%22%0A)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3C%2FCODE%3E%3C%2FP%3E%0A%3CP%3E%E3%81%8A%E3%81%9D%E3%82%89%E3%81%8F%E3%80%81%E5%8C%BA%E5%88%87%E3%82%8A%E6%96%87%E5%AD%97%E3%81%AE%E9%81%B8%E6%8A%9E%E3%81%A8%E3%80%81%E5%88%97%E3%82%92%E8%A4%87%E6%95%B0%E5%9B%9E%E7%AD%94%E3%81%AB%E3%81%99%E3%82%8B%E3%81%8B%E3%81%A9%E3%81%86%E3%81%8B%E3%82%92%E6%B1%BA%E5%AE%9A%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%82%8C%E3%82%89%E3%81%AF%E3%80%81%E5%88%97%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AE%E4%B8%8B%E3%81%AB%E7%95%B0%E3%81%AA%E3%82%8B%E3%82%BB%E3%83%AC%E3%82%AF%E3%82%BF%E3%83%BC%E3%82%92%E6%8C%81%E3%81%A4%E5%88%86%E4%BD%8D%E6%95%B0%E3%81%A8%E5%90%8C%E3%81%98%E6%96%B9%E6%B3%95%E3%81%A7%E5%AE%9F%E8%A1%8C%E3%81%A7%E3%81%8D%E3%82%8B%E5%8F%AF%E8%83%BD%E6%80%A7%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1638360999465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1638360999465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1638360999465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1638360999465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38056i992835CB5E7A530F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1638360999465.png%22%20alt%3D%22jthi_0-1638360999465.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3C%2FCODE%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-441070%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%E3%83%87%E3%83%BC%E3%82%BF%E3%82%A2%E3%82%AF%E3%82%BB%E3%82%B9%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E6%8E%A2%E7%B4%A2%E3%81%A8%E8%A6%96%E8%A6%9A%E5%8C%96%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835467%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Listagg%2FConcatenate%2FGROUP_CONCAT%20%E3%82%92%E3%82%B5%E3%83%9E%E3%83%AA%E3%83%BC%20%E3%83%97%E3%83%A9%E3%83%83%E3%83%88%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%81%AB%E8%BF%BD%E5%8A%A0%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835467%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%E3%83%9B%E3%82%AE%3C%2FA%3E%E3%81%AB%E3%82%88%E3%82%8B%E9%96%A2%E9%80%A3%20%2F%20%E5%90%8C%E3%81%98%E9%A1%98%E3%81%84%3A%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FSummary-and-Tabulate-add-aggregation-option-for-Character%2Fm-p%2F659314%23U659314%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%3CLI-EMOJI%20id%3D%22lia_folded-hands%22%20title%3D%22%3Amanos_unidas_para_la_oraci%C3%B3n%3A%22%3E%3C%2FLI-EMOJI%3E%20%E8%A6%81%E7%B4%84%E3%81%A8%E9%9B%86%E8%A8%88%3A%20%E6%96%87%E5%AD%97%E5%88%97%E3%81%AE%E9%9B%86%E8%A8%88%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3%E3%82%92%E8%BF%BD%E5%8A%A0%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835468%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Listagg%2FConcatenate%2FGROUP_CONCAT%20%E3%82%92%E3%82%B5%E3%83%9E%E3%83%AA%E3%83%BC%20%E3%83%97%E3%83%A9%E3%83%83%E3%83%88%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%81%AB%E8%BF%BD%E5%8A%A0%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835468%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F13734%22%20target%3D%22_blank%22%3E%E3%83%95%E3%82%A9%E3%83%AD%E3%83%BC%3C%2FA%3E%E3%81%AB%E3%82%88%E3%82%8B%E9%96%A2%E9%80%A3%E3%81%99%E3%82%8B%E9%A1%98%E3%81%84%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FSummerize-Summary-aggregation-function-for-character-data-Concat%2Fm-p%2F106999%23U106999%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%E6%96%87%E5%AD%97%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AESummerize%2FSummary%E9%9B%86%E8%A8%88%E9%96%A2%E6%95%B0%E3%80%82%E6%96%87%E5%AD%97%E3%83%99%E3%82%AF%E3%83%88%E3%83%AB%E3%82%92%E3%82%B9%E3%82%AB%E3%83%A9%E3%83%BC%E3%81%AB%E9%80%A3%E7%B5%90%E3%81%99%E3%82%8B%EF%BC%88by%EF%BC%89%3C%2FA%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

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