Hi,
Someone had the same problem over there:
You really need to read it the guy who solved it really knows how to use Dataview
summary:
You need first to apply a heading to each session in your note and each metadata of each “session” must be an item of a list below the heading.
then you need to refer to the position of the element of the list for dataview to find it.
I adapted it for you and it worked:
TABLE without ID
rows.L.Session[0] as Session,
rows.L.Date[1] as Date,
rows.L.Payment[2] as Payment
FROM #test
WHERE file.lists
FLATTEN file.lists AS L
WHERE contains(meta(L.section).subpath, "Session")
GROUP BY file.name + meta(L.section).subpath
SORT rows.file.name ASC