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?
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
Added a feature request here.. Please vote for it if you want this feature!
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
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.