Hide part of table's column

hope this is no duplicate.
I am running a query as:

TABLE WITHOUT ID specialty AS Specialty, file.link AS Disease
FROM "Medicine"
WHERE contains(tags, "disease")
SORT specialty

The result comes like:

I am trying to find a way to remove the repeating “Hematology” (and all repeat entries of this column), as well as remove the (4) indicator from this column name.

Any suggestions?
Thank you!

Found the solution by tinkering.
For reference:

TABLE rows.file.link as Disease
FROM "Medicine"
WHERE contains(tags, "disease")
GROUP BY specialty AS Specialty

made the trick.


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