Dataview table group by substring() shows the substring() and file.name as -

[S1000RR]

Hi,

what is wrong with this simple statement?

TABLE file.name AS "File Name"
FROM "Progs"
GROUP BY substring(file.name, 0, 1) AS "Group"

Result

[holroy]

Whenever you use GROUP BY, all the other results are gathered into the rows object, so try:

```dataview
TABLE rows.file.name AS "File Name"
FROM "Progs"
GROUP BY substring(file.name, 0, 1) AS "Group"
```

[S1000RR]

Perfect