add pivot function to DV

Not planned

Follow

5

Stefan Zehr

• August 01, 2018 13:17

Can you add a function similar to pivot (in SQL Server) or crosstab (in PostgreSQL):

https://www.postgresql.org/docs/9.2/static/tablefunc.html

 

It could be helpful to have a convenient way for converting rows into columns.

 

• Comment actions Permalink

  Official comment

  

  Salvatore Raunich

  • August 07, 2018 23:32

  Hi Stefan,

  thanks for posting your feature to our Data Virtuality Community.

  This feature was actually requested also by other customers and it is already in our todo.

  Right now I cannot give you any concrete estimation when this feature will be implemented and released because we are currently working on a self service web based information tool that will be released within the next major version (2.1). Afterwards we will start planning other features like, for example, PIVOT and UNPIVOT functions.

  I will follow up on your request as soon as I have a more concrete estimation.

  Best regards

  Salvatore

• 0

  Comment actions Permalink

  

  Salvatore Raunich

  • October 27, 2023 18:52

  Hi Stefan,

  I wanted to provide a quick update on this feature request.

  Since my last message, we have released (quite long ago) the UNPIVOT function, which was a highly requested feature from our customers.

  However, unfortunately, PIVOT is still in the backlog, and we currently have no ETA for it.

  Best

  Salvatore

Please sign in to leave a comment.