What I tried
Embedding multiple entries like below in a single note, then using dataview to extract them in a new note.
Input - in daily notes, I have a section for a log like this:
positive:: Curry.
emotions:: Joy.
needs:: Comfort.
traits:: Can cook!
positive:: Curry again.
emotions:: Still joy.
needs:: So good...
traits:: Can really cook!
Output - in a note summarizing all my positives, I have an entry:
TABLE WITHOUT ID positive as "positive", emotions as "emotions", needs as "needs", traits as "traits"
FROM "10_Daily_Notes/Entries"
SORT date(filename) desc
This results in a table where all entries from a single Input note are rendered in a single row of a table in the Output note.
What I’m trying to do
Have a table in the Output note where each entry from an Input note is rendered as a separate row.
Rationale
I dislike logging data into tables, so I’d rather log stuff in daily notes, but I’d like to be assured that if I want to export the data for analysis later, I can transform it into a CSV / Excel table. I’m open to learning and using a simple script e.g. in Python rather than Dataview, if that makes more sense.