How can a perspective table component switch rows and columns?

Ignition
1

I have a database table that I am binding to a Perspective table component. It works great displaying all the rows and columns from the table vertically. Is there a way to display the rows horizontally?

2

Hello Frank_L,

No, there is no way to make the column headers be rows to display horizontally.

But you can submit a feature request to see if this is something that can be implemented in the future. Ignition Features and Ideas | Inductive Automation

3

Added a feature request here.. Please vote for it if you want this feature!

4

You can do this now by managing your Data: [Perspective table] - How to display two columns of row data in multiple lines? - #3 by cmallonee

5

If your backend is SQL server I would recommend pivoting the data in a stored procedure. That's a set-based operation and it can be offloaded from your Ignition Gateway (assuming your SQL server is on another machine). More saleable.

You can probably do this in other SQL technologies but I am certain you can do it in TSQL.