What I’m trying to do
I would like to join multiple tables existing in different notes into a single large table in another note. For example, let’s assume I have three notes - the Index, Note A, and Note B.
Note A has the following content:
A description of stuff in Note A
| Heading A | Heading B |
|---|---|
| Cell A-A1 | Cell A-B1 |
| Cell A-A2 | Cell A-B2 |
Note B has the following content:
Even more things
A description of stuff in Note B
| Heading A | Heading B |
|---|---|
| Cell B-A1 | Cell B-B1 |
Other stuff goes here
I would like the Index note to automatically collect the tables from Note A and Note B into a combined table:
| Heading A | Heading B |
|---|---|
| Cell A-A1 | Cell A-B1 |
| Cell A-A2 | Cell A-B2 |
| Cell B-A1 | Cell B-B1 |
Things I have tried
I’ve looked through the documentation for the Dataview, Meta Bind, Templater, and JS Engine plugins and searched the Obsidian help. The following topic appears to be for the same question: Conjoin tables from different notes into one big table
However, I don’t see how the answer is applicable - as I understand it, dataview queries don’t have the ability to get the contents of a markdown table in a note, as dataview queries only operate on cached data found in the frontmatter of a note.
For single-row tables, it’s trivial to migrate the data from the table into the frontmatter and then use dataview to build that table out, but then you’d need one note per row, which I’d rather avoid.
I’m sure this can be done using sufficient javascript, file reading, and string manipulation, but that seems unlikely to be performant. I’m wondering if I’ve missed something in the design of one of the various plugins to Obsidian that could allow this sort of query to be more practical and without having to engineer a solution from scratch.
Thanks.