add pivot function to DV

Planned

Follow

4

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

Please sign in to leave a comment.