Best way to return earliest of multiple date fields in Magic ETL
I have a dataset that has five dates... I want to add a new column that contains the earliest of those five dates. That is easy to do in a MySQL data flow... but I can't figure it out in Magic ETL (I'm just starting to use Magic ETL more as our dataset sizes are growing and Magic ETL seems to be "faster").
Any help would be appreciated.