Conjoin tables from different notes into one big table

Help
1

What I’m trying to do

Trying to conjoin multiple tables from different notes into one big database so i can view them all at once

joining this table with another of the same kind in a different daily note

Exercise Set Weight Reps
Chest press 1 60kg 8
2 70kg 2
3 40kg 12
Pullups 1 0 8
2 0 9
3 0 8

Tried

done a few things with templater or dataview but havnt figured out a way to draw table data from other notes, there a way to do it?

2

You’ll need to either write one query to catch information from all files, or switch to dataviewjs, do the separate queries and then join the tables using javascript.

3

how do i get the information from the tables with a query?

4

You can do const result = await dv.query(` … `) a few times, and then join the different result.values.