Hi all! I have a table with musical bands grouped by Use (Party, Training, Test, Relax, etc) and/or a combination of both.
I was trying a lot of things, but I feel the problem is fundamental thing.
File estructure (YAML)
---
Use:
Songs: Sleep in the snow, Southern air, Keeper
Highlighted:
---
What I tried to do
'''dataview
TABLE WITHOUT ID rows.file.links as Band, Song, Use, Highlight, Collaboration
FROM <path>
SORT file.mtime ASC
FLATTEN Rows
GROUP BY Use
SORT ROWS
'''
= Achieved
= Not achieved
What I’m trying to do
- Table without id (first column is rows.file.link as Band)
- Sort Alphabetically Ascendant (inside the group)
- Grouped by Use and Sort Alphabetically Ascendant
- Flatten by Use
- Showing Songs, Highlighted and Collaborations
Example
| Band | Song | Use | Highlight | Collaboration |
|---|---|---|---|---|
| prev. bands | other uses | |||
| A-Band #1 | Songs, … | Party | [[Band]], … | |
| B-Band #2 | Songs, … | Party | Highlight | [[Band]], … |
| C-Band #3 | Songs, … | Party | ||
| A-Band #4 | Songs, … | Relax | [[Band]], … | |
| B-Band #5 | Songs, … | Relax | Highlight | [[Band]], … |
| C-Band #6 | Songs, … | Relax | ||
| D-Band #7 | Songs, … | Relax, Training | ||
| A-Band #8 | Songs, … | Test | Highlight | [[Band]], … |
| B-Band #9 | Songs, … | Test, Relax | [[Band]], … | |
| post. bands | other uses |
Extra question
- It’s possible to separate the multiple uses (like Relax, Training) in two separate D-Band #7 rows? like:
Band Song Use Highlight Collaborations D-Band #7 Songs, … Relax [[Band]], … D-Band #7 Songs, … Training [[Band]], …
Thanks a lot beforehand! 