cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Table join with aggregation - options like N, mean, median, min ...

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☐ nice to have

☑ nobody needs it -> use Query builder.

 

 

Hi,

when joining tables, it gets interesting when there are several rows with identical values to match.

The standard approach: for the N idential values in the first table and M identical values in the second table, NxM rows are generated in the joined data table.

 

Another way is to use the "drop multiples" option.

Then just the first row with the respective value makes it into the joined data table and the remaining rows are dropped.

 

my wish:
an option to choose the aggregation method (one drop-down menu for each of the 2 tables)

 

possible options:

the two existing ones:
- no aggregation, NxM
- take the first, drop the rest

... plus some of the aggregations that can be found in the Summary Table menu
 (at least: N, mean, median, min, max, sum)

Holger_0-1647979133108.png

A workaround: first, generate a summary table for one table - and then joint the summary table with table #2 -- or a summary table of table #2.

another workaround: generate columns with the aggregated values first and then join the tables

 

but it would be really cool and convenient if this could be done directly via the join table menu ...

5 Comments
dale_lehman
Level VII

I believe you already have those options if you join the tables using Query Builder instead of Tables-Join.

hogi
Level XII

Oh, right.

Like many times before: already there, you just have to find it

 

Is there a reason why the aggregation is not available directly in the join menu?

hogi
Level XII

The wish can be closed as there is an alternative function available in Jmp.

 

 

hogi
Level XII
Status changed to: Delivered

Thanks for bringing this to my attention! Marking as delivered