First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.
What I’m trying to do
I am using dataview to return queries in Obsidian. I have the properties of Scholar and Chapter (as text). Scholars may appear in multiple chapters. I want a list of Scholars with Chapter it appears in as a list.
Things I have tried
TABLE without ID
Scholars, join(map(list(chapter), (c) => string(c)), ", ") as “Chapter”
FROM “A Happier Bisnis”
WHERE Chapter
FLATTEN Scholars
group by Scholars
SORT Scholars asc