0

Alternative to SQL Window Functions in PQL

I wanted to check if there is any alternative approach in PQL to achieve functionality similar to SQL window functions( for example Row Number() ). 

Any guidance, examples, or documentation references would be greatly appreciated.

Thanks in advance for your support.

3 replies

null
    • VP Product Management
    • Ian_Macdonald
    • 7 days ago
    • Reported - view

    Hi 

    In Pyramid, these are known as Context Calculations. See this Help page for details.

    Hope that helps.

    Ian

    • VP Product Management
    • Ian_Macdonald
    • 7 days ago
    • Reported - view

    BTW, there isn't a context function to generate row numbers directly, but if you create a constant Measure with a value of 1, you can use the Cumulative context function on that to give the row number. If you need the row number at the beginning, consider use of the Tabular Grid to position that Measure first.

    Ian

      • npesarla5171
      • 4 days ago
      • Reported - view

       Thank you for the info

Login to reply

Content aside

  • Status Answered
  • 4 days agoLast active
  • 3Replies
  • 23Views
  • 2 Following