Show a bullet point list as a table with their metadata and sections (headers) as columns

Show list items as table with their metadata and sections

Basic

TABLE WITHOUT ID L.text AS "Food", L.best-before AS "Best before ⬇"
FROM "10 Example Data/food/Food pantry"
FLATTEN file.lists AS L
SORT L.best-before

Variants

Show the headings they belong to as a column

TABLE WITHOUT ID L.text AS "Food", meta(L.section).subpath AS "Type", L.best-before AS "Best before ⬇"
FROM "10 Example Data/food/Food pantry"
FLATTEN file.lists AS L
SORT L.best-before

Remove meta data from bullet point text

TABLE WITHOUT ID regexreplace(L.text, "\[best-before:: [0-9-]+\]", "") AS "Food", meta(L.section).subpath AS "Type", L.best-before AS "Best before ⬇"
FROM "10 Example Data/food/Food pantry"
FLATTEN file.lists AS L
SORT L.best-before