Dataview Table: Occurences with <br> instead of comma

I currently have the following query:

TABLE WITHOUT ID "<strong>[[" + + "|" + dateformat(date(,"ccc dd MMM yyyy") + "]] " + title + "</strong> <br>" + Occurence AS Date
FROM "Reviews/00 Days"
WHERE Week = [[]]
SORT asc

This gives me the result of:

mo 30 jan. 2023 Daily Title
Occurence1, Occurence2, Occurence3

However I’d like to let every occurence start on a new line, something like:

mo 30 jan. 2023 Daily Title

I was trying it with FLATTEN, but that gives me a new row with date-title per occurence and I’d like them to be combined per date-title.

Any help would be very much appreciated!

Try using join(Occurrence, "<br />") to override the default join with comma operation.

Sorry for the brevity, I’m on mobile.

1 Like

That’s it! Thanks a million!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.