Allow Window Functions in MagicETL Formula Tile

MichelleH

It would be helpful to be able to write MagicETL formulas using window functions, similar to in beast mode. While the Rank & Window tile is often sufficient, there are some use cases where having this feature in the Formula tile would simplify the dataflow steps:

• Using a sum window function with unbounded rows
  • This does not work consistently in the Rank & Window tile
• Creating multiple window functions with different partitions
  • Users currently have to create a separate tile for each partition criteria, whereas it would be nice to contain these functions within a single tile
• Adding a case statement within the aggregation
  • In current state this requires adding a calculated field in a forumla tile, then using it in a subsequent Rank & Window tile. It would be simpler to do it all at once in the original formula tile

AndreaHenderson

This is a great callout, and one that we are in the process of resolving. We are working on including Window Functions in v2 of the SQL Tile (v1 is in a very limited beta now). I anticipate we will have Window Functions available in the SQL Tile around the end of the year.