New Formula Functions in Magic ETL

Hi friends,

Just a quick post here to let you know about a couple new formula functions that have been added to the Magic formula editor. Not a big enough thing to warrant its own product release, but just a little note here to let you know about them: 

1. ROW_NUMBER(), which would normally be used with an OVER clause, can now be used without an OVER clause in the Add Formula, Group By, and Filter Rows tiles. It evaluates to an incrementing integer beginning with 1 for each incoming row to the tile. It is especially useful for working with data where the original order is important but there is not a column that contains a value that could be sorted on.
2. DATE() can now be invoked with three integer arguments, the year, month, and day. So to get the 15th of the month of an existing date d, you could write: date(year(d), month(d), 15), which is more elegant than concatenating together a string and parsing it with STR_TO_DATE. (Don't even pretend you've never done that, I've seen what you do…)

Let me know if you have any questions!

Take care,

Your Friendly Neighborhood Magic ETL Product Manager