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

Help
1

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
image

2

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"
```
1 Like
3

Perfect