add pivot function to DV
Not plannedCan 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 actionsOfficial comment
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
-
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.
Comments
2 comments