Very helpful! ❤ Need some advice: My use case is: I have a list of songs as atomic notes. I have a list of albums as atomic notes. Songs first appear on an album in a position, ie. the last song, second song, etc on the album. The same song may also appear on a different album, like a compilation album, or a live album, in a different position in the track list. Or if I’m building a list of concert set lists, it may have been performed hundreds of times. What’s the best way generate track lists containing the songs? I was thinking the song would have tags for each album on which it appears, but that omits the track number on that album. I could have a second tag, like album name and track number, but that doesn’t seem like it would scale very well for concert lists. Any recommendations for how to do this with dataview? Extra complexity I can skip if not feasible: I also want to include other data for the song. For example, a live version one night might be a different run time. Say, someone took a long solo, or there was an extended jam, etc.
Hi doug and thank you! Let's say you have 2 albums: - Album Studio - Album Live You have 4 songs that are in both of the albums: - Song A - Song G - Song M - Song X In your song note, you can create a property list called "album(s)". Inside this list you can write the internal link to the albums notes. In the body of each song note you can create a "Track Number" section and inside it you can write some inline metadata. For example, let's say that the "Song A" is the third track of the "Album Studio" and the second track of the "Album Live". Under the "Track Number" section of your "Song A" note, you can write: - album_studio:: 3 - album_live:: 2 Inside you "Album Studio" note, the dataview query will be something like this (the "file . link" it's without spaces, I just used the spaces to avoid creating a clickable link in the comment): ```dataview table without id file . link as Songs where contains(albums,this.file.link) sort album_studio ``` And for the "Album Live" note, will be something like (the "file . link" it's without spaces, I just used the spaces to avoid creating a clickable link in the comment):: ```dataview table without id file . link as Songs where contains(albums,this.file.link) sort album_live ``` Hope an example like this can inspire you to find the best solution for you! Cheers
Hi Marco, I really like your videos and how you explain them. Question: Is there a way to combine data from different files in one row? Lets say I have a file Peter and this file containes the metadata FirstName and FamilyName. I will make some notes according Peter in this file. Now I also have a file Peter_Privat and in this file I have some privat information of Peter. Lets say his PrivatMobileNumber. Now I also have a file Peter_Biz and in this file I have some information according our business relation. Lets say his BizPhoneNumber. Is it now possible to build a table where one row contains the name Peter, his PrivatMobileNumber and his BizPhoneNumber ? Thanks a lot, Marco
Hi Marco and thank you very much! The question you are asking is possible somehow but you need to create at least a link between the notes. Following your example: File named Peter has the following metadata: - FirstName: Peter - FamilyName: Griffin - Priv_Phone: Peter_Privat - Biz_Phone: Peter_Biz Inside the file “Peter_Privat” and “Peter_Biz” you have the PrivatMobileNumber and the BizPhoneNumber. The final query can be something like this: table without id FirstName as First Name, link(Priv_Phone).PrivatMobileNumber as “Private Number”, link(Biz_Phone).BizPhoneNumber as “Business Phone” from “folder name” Hope the example is clear. If not, ask me or dm me somewhere. Cheers!
Hi @@Marco_Mindstone , thanks for your answer, really great 👍 But I have to say, that was not, what I wanted to do. I only onted to have some Metadata in the main document. The other Metadata should be in other documents. There are two reasons: 1) I want to have many Metadata to query them into a dataview, and I would like to have the Metadata showen at the top of the docuent and at the same time I dont want to have such a long list as 20 or 30 Metadata at the top of the page. (As I know, there is no possebility to Collaps the Metadata as it is possible with Headlines.) 2) I would like to seperate some different kind of data in different files. As I understood, in your example you put all data to the main document and then query them into the sub documents - so my understanding. What I would like to do: Main document: - Metadata A: - Metadata B: SubDocument-Privat: - Metadata C: - Metadata D: SubDocument-Biz - Metadata E: - Metadata F: Now I want to have an other document Contacts-Dataview. Here I want to show data to different persons. The topic is, that I would like to have information from the main document as well as from the sub documents. I can think about two ways, how that maybe can be possible. 1) All Documents have the same name at the beginning. The sub documents yust have some additional naming at the end. Example: - PeterPahn - PeterPhan_privat - PeterPahn_biz 2) The second way that maybe will work is to have link-metadata in the main document and with that information point to the sub documents. According to the example at the top I would add to meta data entrys to PeterPahn. - privatInfo: [[PeterPahn_privat]] - bizInfo: [[PeterPahn_biz]] With the second version it is maybe possible to say in the query of the dataview. There is a metadata called privatInfo. Take the document, it links to and from there get the metadata phoneNumber. Oh, maybe there is a third solution. I have the documents - PeterPahn - PeterPahn_privat - PeterPahn_biz and now also PeterPahn_metaData. Here with two subversions. a) have the metadata in the documents as in the first version. Now move the information somehow to PeterPahn_metaData. Now make the query to the files *_metaData. b) Write all metadata (biz, privat, ...) into PeterPahn_metaData. Now its no problem to make all the dataview querys to the *_metaData files. But in that situation: How can I get some of the metadata information into the other files. For shure, I could also make a dataview query and get the data into the other documents. But that is not so nice because all values will be in one row and I also have to scroll from left to right to see all information. Is it maybe possible to query metadata into text blocks? Something like: "Peter Pahns privat number is [queryToPeterPahn_privat/privatMobileNumber]." and instead of the query the result - the phone number is showen. Sorry, a long text. On one hand it is more to read what takes time and on the other hand it maybe makes clear, what I want to do. Many thanks, Marco
@@marcorobbe9003 Hi Marco, I will try to go in order. You can collapse properties as you do with headers (screenshot: ibb.co/LS1nJhX) You can also see the properties of the file in the sidebar (screenshot: ibb.co/nD65kYB) About your examples, you wrote: - privatInfo: [[PeterPahn_privat]] - bizInfo: [[PeterPahn_biz]] The example I wrote in my comment was the same. I repeat it using some more info you wrote in your last comment. You have 3 file: "PeterPahn", "PeterPahn_privat" and "PeterPahn_biz". Properties in "PeterPahn": - FirstName: Peter - FamilyName: Pahn - privatInfo: [[PeterPahn_privat]] - bizInfo: [[PeterPahn_biz]] Properties in "PeterPahn_privat": - phoneNumber: 27262626262 - email: privat@email.mail Properties in "PeterPahn_biz": - phoneNumber: 928374655 The dataview query will be: ```dataview table without id FirstName as Name, privatInfo.phoneNumber as "Private Number", privatInfo.email as Email, bizInfo.phoneNumber as "Business Number" from "People" ``` The result will be a table with: - the first name retrieved from the property "FirstName" from the file "PeterPahn". - the private phone number retrieved from the property "phoneNumber" from the file "PeterPahn_privat" - the private email retrieved from the property "email" from the file "PeterPahn_privat" - the business phone number retrieved from the property "phoneNumber" from the file "PeterPahn_biz". Cheers!
@@Marco_Mindstone Wow, great and a very big thank you for your support and giving the example once again in more detail. Big big thanks - waiting for some more great obsidian videos. If you would like to have an idea. To me it would be interesting, what are your learnings about metadata. What information are you using at what time? Meaning, I saw some videos, where hashtags are used in the metadata. In my actual opinion it makes not to much sence to use hashtags in metadata. Maybe working together with several peaople in one vault would be interesting as well. There are not so much videos according that topic - ok maybe also becaouse obsidian is not the best tool to work together with different people.
@@marcorobbe9003 I already have in my “to publish” list, something regarding my vault structure and how I classify and organize my notes. Thank you, Marco!
🚀 Subscribe to my bi-weekly newsletter for free, or become an Insider: www.mindstoneconsulting.net/#/portal/
You are awesome, Marco! Neat & tidy explanation.
Thank you very much!
Very helpful! ❤ Need some advice: My use case is:
I have a list of songs as atomic notes.
I have a list of albums as atomic notes.
Songs first appear on an album in a position, ie. the last song, second song, etc on the album.
The same song may also appear on a different album, like a compilation album, or a live album, in a different position in the track list. Or if I’m building a list of concert set lists, it may have been performed hundreds of times.
What’s the best way generate track lists containing the songs?
I was thinking the song would have tags for each album on which it appears, but that omits the track number on that album.
I could have a second tag, like album name and track number, but that doesn’t seem like it would scale very well for concert lists.
Any recommendations for how to do this with dataview?
Extra complexity I can skip if not feasible:
I also want to include other data for the song. For example, a live version one night might be a different run time. Say, someone took a long solo, or there was an extended jam, etc.
Hi doug and thank you!
Let's say you have 2 albums:
- Album Studio
- Album Live
You have 4 songs that are in both of the albums:
- Song A
- Song G
- Song M
- Song X
In your song note, you can create a property list called "album(s)". Inside this list you can write the internal link to the albums notes.
In the body of each song note you can create a "Track Number" section and inside it you can write some inline metadata.
For example, let's say that the "Song A" is the third track of the "Album Studio" and the second track of the "Album Live". Under the "Track Number" section of your "Song A" note, you can write:
- album_studio:: 3
- album_live:: 2
Inside you "Album Studio" note, the dataview query will be something like this (the "file . link" it's without spaces, I just used the spaces to avoid creating a clickable link in the comment):
```dataview
table without id
file . link as Songs
where
contains(albums,this.file.link)
sort album_studio
```
And for the "Album Live" note, will be something like (the "file . link" it's without spaces, I just used the spaces to avoid creating a clickable link in the comment)::
```dataview
table without id
file . link as Songs
where
contains(albums,this.file.link)
sort album_live
```
Hope an example like this can inspire you to find the best solution for you!
Cheers
Brilliant! 🎉 THANK YOU Marco! 🙏
@@douggottlieb Glad to help you Douglas! And happy new year :)
You too! 🙏
Hi Marco, I really like your videos and how you explain them.
Question: Is there a way to combine data from different files in one row?
Lets say I have a file Peter and this file containes the metadata FirstName and FamilyName. I will make some notes according Peter in this file.
Now I also have a file Peter_Privat and in this file I have some privat information of Peter. Lets say his PrivatMobileNumber.
Now I also have a file Peter_Biz and in this file I have some information according our business relation. Lets say his BizPhoneNumber.
Is it now possible to build a table where one row contains the name Peter, his PrivatMobileNumber and his BizPhoneNumber ?
Thanks a lot, Marco
Hi Marco and thank you very much!
The question you are asking is possible somehow but you need to create at least a link between the notes. Following your example:
File named Peter has the following metadata:
- FirstName: Peter
- FamilyName: Griffin
- Priv_Phone: Peter_Privat
- Biz_Phone: Peter_Biz
Inside the file “Peter_Privat” and “Peter_Biz” you have the PrivatMobileNumber and the BizPhoneNumber.
The final query can be something like this:
table without id
FirstName as First Name,
link(Priv_Phone).PrivatMobileNumber as “Private Number”,
link(Biz_Phone).BizPhoneNumber as “Business Phone”
from “folder name”
Hope the example is clear. If not, ask me or dm me somewhere.
Cheers!
Hi @@Marco_Mindstone , thanks for your answer, really great 👍
But I have to say, that was not, what I wanted to do.
I only onted to have some Metadata in the main document. The other Metadata should be in other documents.
There are two reasons:
1) I want to have many Metadata to query them into a dataview, and I would like to have the Metadata showen at the top of the docuent and at the same time I dont want to have such a long list as 20 or 30 Metadata at the top of the page.
(As I know, there is no possebility to Collaps the Metadata as it is possible with Headlines.)
2) I would like to seperate some different kind of data in different files.
As I understood, in your example you put all data to the main document and then query them into the sub documents - so my understanding.
What I would like to do:
Main document:
- Metadata A:
- Metadata B:
SubDocument-Privat:
- Metadata C:
- Metadata D:
SubDocument-Biz
- Metadata E:
- Metadata F:
Now I want to have an other document
Contacts-Dataview.
Here I want to show data to different persons.
The topic is, that I would like to have information from the main document as well as from the sub documents.
I can think about two ways, how that maybe can be possible.
1) All Documents have the same name at the beginning. The sub documents yust have some additional naming at the end.
Example:
- PeterPahn
- PeterPhan_privat
- PeterPahn_biz
2) The second way that maybe will work is to have link-metadata in the main document and with that information point to the sub documents.
According to the example at the top I would add to meta data entrys to PeterPahn.
- privatInfo: [[PeterPahn_privat]]
- bizInfo: [[PeterPahn_biz]]
With the second version it is maybe possible to say in the query of the dataview. There is a metadata called privatInfo. Take the document, it links to and from there get the metadata phoneNumber.
Oh, maybe there is a third solution.
I have the documents
- PeterPahn
- PeterPahn_privat
- PeterPahn_biz
and now also PeterPahn_metaData.
Here with two subversions.
a) have the metadata in the documents as in the first version. Now move the information somehow to PeterPahn_metaData.
Now make the query to the files *_metaData.
b) Write all metadata (biz, privat, ...) into PeterPahn_metaData.
Now its no problem to make all the dataview querys to the *_metaData files.
But in that situation: How can I get some of the metadata information into the other files.
For shure, I could also make a dataview query and get the data into the other documents. But that is not so nice because all values will be in one row and I also have to scroll from left to right to see all information.
Is it maybe possible to query metadata into text blocks?
Something like:
"Peter Pahns privat number is [queryToPeterPahn_privat/privatMobileNumber]." and instead of the query the result - the phone number is showen.
Sorry, a long text. On one hand it is more to read what takes time and on the other hand it maybe makes clear, what I want to do.
Many thanks, Marco
@@marcorobbe9003 Hi Marco, I will try to go in order.
You can collapse properties as you do with headers (screenshot: ibb.co/LS1nJhX)
You can also see the properties of the file in the sidebar (screenshot: ibb.co/nD65kYB)
About your examples, you wrote:
- privatInfo: [[PeterPahn_privat]]
- bizInfo: [[PeterPahn_biz]]
The example I wrote in my comment was the same. I repeat it using some more info you wrote in your last comment.
You have 3 file: "PeterPahn", "PeterPahn_privat" and "PeterPahn_biz".
Properties in "PeterPahn":
- FirstName: Peter
- FamilyName: Pahn
- privatInfo: [[PeterPahn_privat]]
- bizInfo: [[PeterPahn_biz]]
Properties in "PeterPahn_privat":
- phoneNumber: 27262626262
- email: privat@email.mail
Properties in "PeterPahn_biz":
- phoneNumber: 928374655
The dataview query will be:
```dataview
table without id
FirstName as Name,
privatInfo.phoneNumber as "Private Number",
privatInfo.email as Email,
bizInfo.phoneNumber as "Business Number"
from "People"
```
The result will be a table with:
- the first name retrieved from the property "FirstName" from the file "PeterPahn".
- the private phone number retrieved from the property "phoneNumber" from the file "PeterPahn_privat"
- the private email retrieved from the property "email" from the file "PeterPahn_privat"
- the business phone number retrieved from the property "phoneNumber" from the file "PeterPahn_biz".
Cheers!
@@Marco_Mindstone Wow, great and a very big thank you for your support and giving the example once again in more detail.
Big big thanks - waiting for some more great obsidian videos.
If you would like to have an idea.
To me it would be interesting, what are your learnings about metadata. What information are you using at what time? Meaning, I saw some videos, where hashtags are used in the metadata. In my actual opinion it makes not to much sence to use hashtags in metadata.
Maybe working together with several peaople in one vault would be interesting as well. There are not so much videos according that topic - ok maybe also becaouse obsidian is not the best tool to work together with different people.
@@marcorobbe9003 I already have in my “to publish” list, something regarding my vault structure and how I classify and organize my notes.
Thank you, Marco!
Wow. I did find this helpful.
Thank you! Glad to hear that.
Ed io che facevo tutto a manina… grazie
Non c’è di che! ;)