12 August 2025

Window script function enhancements

Share this message

The syntax, functionality, and documentation of window functions have been enhanced to improve usability and flexibility. Window functions are commonly used for analytics and ML data preparation scenarios that require aggregations across different partitions without losing the grain of the input data.

Enhancements include:

  • Added support for performing aggregations on data ordered by a specified sorting expression, enabling sorted sliding windows instead of relying on the default load order.

  • Clarified documentation and improved behavior when handling optional parameters

  • Fixed an issue where the WRank function returned incorrect values when nested inside another expression.

Window – Script function

How can we help?

Whether something’s still unclear or you’re ready to take the next step, Barry and Eric are happy to talk it through. Email us, call us, or book a meeting at a time that works for you.