KeyValue Component with Multiple Columns

[marc]

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?

[everett_smith]

Hi @marc, If it's still helpful, this isn't supported out of the box in Retool. It should be possible with a custom component or with a JS transformer. Some solutions are discussed in this other community post