cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-608297%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20aggregation%20option%20for%20virtual%20joins%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-608297%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F42584%22%20target%3D%22_blank%22%3E%40Sarah-Sylvestre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20functionality%20could%20help%20a%20lot%20to%20improve%20the%20usability%20of%20virtual%20joins.%3CBR%20%2F%3E(I%20admit%3A%20definitely%20not%20at%20the%20same%20speed%20that%20we%20enjoy%20without%20aggregation)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-609736%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20aggregation%20option%20for%20virtual%20joins%20-%20Status%20changed%20to%3A%20Acknowledged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-609736%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EThank%20you%20for%20all%20the%20information%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%40hogi%3C%2FA%3E!%20Your%20request%20has%20been%20captured%20and%20will%20be%20prioritized.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-473024%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3Eaggregation%20option%20for%20virtual%20joins%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-473024%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E2%98%90%26nbsp%3Bcool%20new%20feature%3CBR%20%2F%3E%E2%98%90%26nbsp%3Bcould%20help%20many%20users!%3C%2FP%3E%3CP%3E%E2%98%90%26nbsp%3Bremoves%20a%20%E2%80%9Ebug%E2%80%9C%3C%2FP%3E%3CP%3E%E2%98%91%26nbsp%3Bnice%20to%20have%3C%2FP%3E%3CP%3E%E2%98%90%20nobody%20needs%20it%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fforums%2Fsearchpage%2Ftab%2Fmessage%3Ffilter%3Dlocation%2CauthorId%26amp%3Bq%3Dfeature%26amp%3Blocation%3Didea-board%3Ajmp-wish-list%26amp%3Bauthor_id%3D26800%22%20target%3D%22_self%22%3Eother%20wishes%20submitted%20by%26nbsp%3B%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59505i92BA52D1289B6F5C%2Fimage-dimensions%2F36x39%3Fv%3Dv2%22%20width%3D%2236%22%20height%3D%2239%22%20role%3D%22button%22%20title%3D%22hogi_2-1702196401638.png%22%20alt%3D%22hogi_2-1702196401638.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20idea%3A%3C%2FP%3E%3CP%3Eif%20there%20is%20no%20unique%20identifier%20for%20virtual%20join%20--%20add%20the%20possibility%20to%20define%20an%20aggregation%20to%20generate%20unique%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3Eno%20need%20to%20have%20a%20%3CSTRONG%3Eunique%3C%2FSTRONG%3E%20identifier%20for%20virtual%20joins%20anymore%3C%2FLI%3E%3CLI%3Ea%20default%20option%20for%20data%20aggregation%20%5B%22median%22%20would%20be%20cool%2C%20but%20just%20works%20for%20numbers%3B%20so%20the%20not%20so%20useful%20%22N%22%3F%5D%3CBR%20%2F%3E%2B%20a%20possibility%20to%20define%20the%20aggregation%20individually%20for%20each%20column%20(like%20in%20the%20query%20builder)%3C%2FLI%3E%3C%2FUL%3E%3CP%3Ethe%20benefit%3A%3C%2FP%3E%3CUL%3E%3CLI%3Ethe%20aggregation%20option%20makes%20the%20virtual%20join%20much%20more%20versatile%3C%2FLI%3E%3CLI%3Ethe%20virtual%20join%20is%20almost%20as%20%22dynamic%22%20as%20the%20link%20functionality%20of%20summary%20table%20(%26lt%3B-%26gt%3B%26nbsp%3B%20Query%20Builder)%3C%2FLI%3E%3CLI%3Evirtual%20links%20survive%20after%20the%20data%20is%20saved%20and%20re-opened%20(%26lt%3B-%26gt%3B%20link%20table)%3C%2FLI%3E%3C%2FUL%3E%3CP%3Ethe%20disadvantage%3A%3C%2FP%3E%3CP%3Ethe%20aggregation%20will%20slow%20down%20the%20virtal%20join.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20woraround%3A%3C%2FP%3E%3CUL%3E%3CLI%3Eaggregation%20via%20summary%20table%3C%2FLI%3E%3CLI%3Ejoin%20via%20virtual%20link%3C%2FLI%3E%3CLI%3Eimportant%3A%20save%20as%20a%20script%3CBR%20%2F%3E(to%20establish%20the%20dynamic%20link%20again%20after%20it%20got%20lost%20after%20saving%20the%20file)%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-473024%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EData%20Access%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
0 Kudos

aggregation option for virtual joins

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

other wishes submitted by  hogi_2-1702196401638.png

 

The idea:

if there is no unique identifier for virtual join -- add the possibility to define an aggregation to generate unique values.

 

  • no need to have a unique identifier for virtual joins anymore
  • a default option for data aggregation ["median" would be cool, but just works for numbers; so the not so useful "N"?]
    + a possibility to define the aggregation individually for each column (like in the query builder)

the benefit:

  • the aggregation option makes the virtual join much more versatile
  • the virtual join is almost as "dynamic" as the link functionality of summary table (<->  Query Builder)
  • virtual links survive after the data is saved and re-opened (<-> link table)

the disadvantage:

the aggregation will slow down the virtal join.

 

the woraround:

  • aggregation via summary table
  • join via virtual link
  • important: save as a script
    (to establish the dynamic link again after it got lost after saving the file)
2 Comments
hogi
Level XII

@Sarah-Sylvestre 

this functionality could help a lot to improve the usability of virtual joins.
(I admit: definitely not at the same speed that we enjoy without aggregation)

Status changed to: Acknowledged

Thank you for all the information @hogi! Your request has been captured and will be prioritized.