Back to Geneos FAQ

Internal documentation only

This page has been marked as draft.

How to transpose columns to rows of the table on SQL-Toolkit

Request Copied

• The columns are displayed horizontally instead of vertically, and there is another way to transpose columns to rows.

  The default format of the dataview:

Answer(s) Copied

• The answer to asking if there’s another way to transpose columns to rows is no and not supported.

This format was not supported:

• Compute Engine is an alternative but if there are lots of columns then this could be laborious to make rules (to populate data) for each row.
• The alternative way is to create a toolkit script so that the user can directly interact with the MySQL client.

Question Copied

• In MySQL, you can end a query with a ‘\G’ rather than a ‘;’?

Answer(s) Copied

• As per MySQL documentation, the command \G should work:

  

• ego (\G) Send command to mysql server, display result vertically.

Reference Copied

• https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html