Summarize tool based on unique ID

[utkarsh9771]

I want to get MAX date and MIN date based on unique ID

I also want all the records plus 2 new columns called Max Date & Min Date

[griffinwelsh]

@utkarsh9771 take the steps below. Mark solved if this solved your issue. Let me know if you have any questions.

1. Use the summarize tool. Group by unique ID, Min date, Max date

2. Join the summarize tool output with the original data set on unique id.

[binu_acs]

@utkarsh9771 similar to @griffinwelsh approach