Min & Max Date Per Row (Across Several Columns)

[AlteryxUserFL]

Besides using a large number of if statements, is there an easy way to determine the min or max date per row across several columns? See below for example: 

ID	Date 1	Date 2	Date 3	Max Date
1	1/1/2019	5/1/2019	1/1/2019	5/1/2019
2	10/01/2019	1/1/2019	5/1/2019	10/01/2019
3	10/01/2019	10/01/2019	5/1/2019	10/01/2019
4	1/1/2019	1/1/2019	1/1/2019	1/1/2019

[echuong1 · Accepted solution]

You can use the transpose tool to get all of the values in one column. From there you can use the summarize tool with a group by on the ID field to get the max date. See attached for an example. 

[RolandSchubert · Accepted solution]

Hi @AlteryxUserFL ,

you could use the Transpose tool to convert columns to rows using "ID" as the key column, use a Summarize tool to find the MAX value (group by ID) and join the result to your original data. But - first you'll have to convert your dates to "Date" data type (and re-convert at the end). I've attached a sample workflow.

Regards

Roland