Help Desk

Submit a ticket My Tickets

Tabular Transformation - Advanced Query

Does Advanced query command support functions like pivot/unpivot in the sql select query ?

  • Hi Ankit,

    The Advanced Query Command leverages a SQLite database which does not support the PIVOT function.  The functions supported by SQLite can be found here: 

    Some OneCloud users have accomplished pivoting a data set by using GROUP BY statements.  If you post a sample data set (please ensure you are not posting real data) and a summary of the pivot requirement, we can help you with a sample SQL statement.

    1 person likes this
  • Hi Tony,

    Thanks for the info. I am good with the SQL but just wanted to check if those functions were available. 



Login to post a comment