Multi-row formula indb (windowing)

[simonaubert_bd]

Hello all,

We all love pretty much the in-memory multi-row formula tool. Easy to use, etc. However, the indb counterpart does not exist.

I see that as a wizard that would generate windowing functions like LEAD or LAG
https://mode.com/sql-tutorial/sql-window-functions/

Best regards,

Simon

[jhertel]

This is such a foundational function for analyzing behavior changes in transactional data. It's a breeze on desktop and a complete nightmare in-db. I will now have to stream in and out (takes 12 minutes) because this functionality doesn't exist; debugging this will take forever. Please add this!! In-db is all I'm doing as all my data is either in AWS or Snowflake.