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 |
Solved! Go to 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