This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Choose Language Hide Translation Bar
Group Listagg Columns
jthi
Super User jthi
Super User
Created: Mar 17, 2022 04:20 AM  |  Last Modified: Mar 16, 2022 06:48 AM
JMP-Tools Group Listagg Columns.jmpaddin

Purpose of this addin is to provide a way for user to create new table with a column(s) of grouped values in similar manner as SQL's listagg. In best case this option would be in JMP's Summary and Split platforms as from time to time I would like to keep some values even if I split or aggregate with Summary. I have created wish list items for both of those Split (wish list)  and Summary (wish list) table (I might add feature to this addin which would allow user to do Split and/or Summary with listagg).

 

GUI:

jthi_0-1644597436922.png

Resulting table:

jthi_1-1647427059213.png

 

Combining previous table with Summary table allows me to see all names and ages for each sex while still seeing means of height and weight:

jthi_2-1647427114447.png

 

Options

  • Suffix
    • Suffix which will be added to columns
  • Multiple response
    • Used to determine if new columns should have multiple response Modeling Type

You can post improvement ideas here here or in open issue in GitHub - Group Listagg Columns .

 

This tool is part of JMP-Tools I have been working on for some time now and I will release more Add-Ins when time permits in JMP Community.