"GROUP BY" data command results in disappearing field values in table query.

[belindakwan]

Hi all,

When using the "GROUP BY" data command, the field values in my table under all other field names/categories disappear ... does anyone know why this might be the case?

For context, the first image is what I get when I use the following code:

TABLE reqDesc, reqTags
WHERE file.folder=this.file.folder

The second image is what I get when I use the following code:

TABLE reqDesc
WHERE file.folder=this.file.folder
GROUP BY reqTags

Why do my reqDesc field values disappear when I group by reqTags?

I'm new to Obsidian ... so this may be a silly question ... but I can't find the answer no matter how much I search.

TIA!