Allow Window Functions in MagicETL Formula Tile

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

5 votes

Active · Last Updated