#1

Hello,

I am experimenting with the Dataview plugin and have problem with the GROUP keyword.

Example: There are notes which have an “intensity” field.
This query should output a table which shows the intensities and the file names associated with it:

TABLE intensity, rows.file.name
GROUP BY intensity

But what comes out is this:

image

=> Why do I get this extra Column “Group” when I am only selecting two fields?

Thanks in advance,
Simon

#2

If in “normal” query by default the first column is related to “File”, when in queries with “group” by default the first column is related with the grouped field… so, you don’t need to repeat “intensity”. If you want to change the name, write this:

TABLE WITHOUT ID intensity AS "Intensity", rows.file.name AS "Notes"
GROUP BY intensity

“WITHOUT ID” removes the default first column.

#3

…perfect answer. Sorry, did not notice this in the docs. :smiling_face:
THANKS!

#4

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