I use the metada to put some information by category.
Exemple I have files with this metadata
fonctions: f1, f2
fonctions: f1, f3
fonctions: f2, f3
I would like to create a table (with Dataview) which will show all the occurrence of each “fonctions” and put to the next column all the file linked
|f1||2||file 1, file 2|
|f2||2||file 1, file 3|
|f3||2||file 2, file3|
TABLE length(rows) as "Nbre occurrence" , join(rows.file.link, ", ") as "Note" where fonctions group by join(fonctions, ", ") as "fonction"
The result table show something like this :
|f1, f3||1||file 2|
It looks like Dataview does not read string between comma separatly.
Any help would be appreciated !