Displaying the same data from a database table in multiple columns of a Perspective Table

perspective
database
#1

Hello,

I’m working on a Perspective Table that is populated by a SQL Query of a Database Table. Each row in the DB Table has a unique ID, which I’m hoping to use inside my Perspective Table in four separate columns to perform different table manipulations. The problem I am having is that the Perspective Table only allows one column to pass the rowID from the SQL Query, meaning that only 1/4 of the columns appear in the Table, while the rest of the columns pass in the next available column data from the SQL Query of the DB. I’m wondering if having one column with a vertical ellipsis that will open the four options is an easier path to follow, both from a designer and a user perspective. Any feedback or suggestions is greatly appreciated! Thanks in advance.

0 Likes