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