Add MIN and MAX aggregates for string column

GrantSmith
GrantSmith Coach
edited February 17 in Ideas Exchange

A lot of times I'm processing data within Magic ETL 2.0 and need to take the minimum or maximum of a string column after a group by however in Magic 2.0 it's not an option in the group by tile. It'd be great if these aggregate functions were added as part of the group by tile.

**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
Tagged:
3
Up
3 votes

· Last Updated

Comments

  • GrantSmith
    GrantSmith Coach

    It is possible to utilize a Rank tile to calculate the rank by sorting the column and then filter for rank 1, then joining back to the original dataset however it'd be easier and simpler if MIN and MAX were just included in the options in the Group By tile.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
This discussion has been closed.

Categories