Hi, when I use dataview with table, pulling data from a folder, it creates a first column File
, that precedes the columns I declared, and I don’t know how to rename the first column or remove it. For example,
```dataview
table name as Name, email as "Email", phone as Phone
from "contacts"
sort name
```
The output table has four columns : “File, Name, Email, Phone” . I would like to either:
- omit the “File” and just use the three that I declared (preferred)
- rename the “File” column to something else (“Name”), rename the files to be the person’s name, and delete the Name column from the query.
within the “contacts” folder, each file has a yaml header
---
name: Jon
email: "[email protected]"
phone: "000-111-2222"
---
Things I have tried
I’ve tried adding “file.name as X”, which adds an X column, but doesn’t rename the one called ‘File’.
I’ve tried searching this forum and googling but I haven’t found the answer.
Even the example on the front page of the dataview git repo shows a first column “Name” - I don’t know how to reproduce that. (Also, the example query uses lower case column headings and the Preview view has upper case column headings. That’s another difference from what my version of the software does)
This is a new installation, with Osidian v0.11.13 and dataview v0.2.17
Thanks in advance!