List a property of a linked file

What I’m trying to do

I have two files. The first one is called ‘original’, the second is called ‘translation’.

In the ‘original’ file, I have two frontmatter properties:
publication date: 2023-12-01
translation: “[[translation]]”

In the ‘translation’ file, I have two frontmatter properties:
publication date: 2023-12-02
translation: “[[original]]”

How can I create a table of all files that has three columns:

  • file name
  • publication date of this file
  • publication date of the translation file (given the link in the translation property)

I hope this makes sense and I highly appreciate any help as it would improve my workflow a great deal!!

How do you differentiate between the original and the translation file?

Does the following query help you on the way to enlightenment:

```dataview 
TABLE publication-date as "org date", translation.publication-date as "translation date"
WHERE publication-date
```

Now it’s tested, and verified that it looks up the value of the property publication date in the file linked by the translation property. Notice how the space in your field name is translated into a hyphen/dash/… to normalise the field name.

1 Like

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