In my workflow I have used the summarize tool to group BY PROD ID to find the MAX Date but at the same time I need the relevant CAT ID (A-23) to be included in my output.
Attached the workflow Any thoughts Please.
Hi @micky01,
You can use a join tool after your summarize tool to bring back that extra info for CAT ID.
Hope that helps,
Regards,
Angelos
Hello Angelos
Thank you so much the solution works just one quick question.
After the Summarize tool in the second Join why we are Joining the MAX Date and Date on Join by specific fields configuration ? can you please explain.
Many Thanks
