Hi Guys,
I have a column of dates in Alteryx - Using the formulae tool I want to create a new column with the MAX date from the column of dates
Regards,
Tommy
Hi @Tommy_Alterax
Nope thats not possible. You need to find max using summarize and use append tool to add it back.
Honestly its not that complex. Workflow will look like this.
Hope this helps 🙂
You can use a summarize tool and get max.
https://help.alteryx.com/current/designer/summarize-tool
@Tommy_Alterax ,
I'd like to add to @atcodedog05 and suggest that you want to use the APPEND FIELDS tool to add the max date value(s) onto the original records.
cheers,
mark
Hi - i dont want to break up my data and rejoin it then - Is there a way to do this using a formuale tool to create a new column and insert the max date out of all the months
