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

[hogi]

☐ 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)

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 ...

[dale_lehman]

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

[hogi]

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]

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

[hogi]

@Sarah-Sylvestre 

[Sarah-Sylvestre]

Thanks for bringing this to my attention! Marking as delivered