I am trying to build a feature comparison tool. It should allow a user to select multiple rows from a table (items) and view all the information for those items as columns in a list (features of those items).
I have tried (unsuccessfully) to use PIVOT in a SQL command and insert it into a table (it doesn't look like PIVOT/UNPIVOT are supported in Retool?) but, even if that worked, it would be a less elegant solution than if there were a component similar to KeyValue that allowed multiple columns.
Is there a way to do this?