[Feature Request/Question] Tables of data derived from notes, particularly frontmatter arrays about obsidian-dataview HOT 9 CLOSED

Confirmed to be included in 0.2.0, using the FLATTEN command, like so:

TABLE owner, pet FROM #owners
FLATTEN pets AS pet

from obsidian-dataview.

Interesting! So essentially flatten arrays/maps (so one logical row per entry, per file) and do a query over that. Implementation wise it doesn't seem too bad, it would just complicate the FROM block somewhat. Perhaps a separate FLATTEN operation would make the query simpler (so it would look like)

```dataview
table pets.name, pets.age, owners.name as "parent note"
unnest pets
from "pet-owners"
```

I'll probably look at this at some point in the future, but would be happy to consult if you want to take a look at the feature yourself.

from obsidian-dataview.

The syntax may look a little different than what I mentioned above, but this will be coming as part of pipeline queries in 0.2.0, the release after the upcoming release.

from obsidian-dataview.

Yes, exactly! I like the idea of an unnest query term, it hints at multi-level unnesting 😀

I'll take a look at this in the next few weeks; if you get to it first, all the better.

from obsidian-dataview.

+1 for me. This would rock

from obsidian-dataview.

Legend. This will be magnificent.

p.s. Thanks for this plugin. I has totally transformed my workflow. Really REALLY appreciate your work.

from obsidian-dataview.

Amazing! And ditto, such valuable work.

from obsidian-dataview.

I'm literally refreshing your github every few hours waiting for this release 😂

Super excited

from obsidian-dataview.

Released as part of 0.2.0; let me know if you encounter any problems.

from obsidian-dataview.