What I’m trying to do
I currently have notes related to a music artist/band. In the note I have properties for members (current band members) and past-members (members that were previoulsy in the band).
I want to create a dataview table showing all the bands that a musician has been in. However in some cases the musician would be in the members property and sometimes the past-members.
Is there a way I can somehow merge the individuals from members and past-members.
Table should output the member and related band/s
Things I have tried
Sorry, I have no idea where to start with this.
Thanks in advance…