last person to submit a ticket

[Saravanan13]

Hello all,

I am looking to find the processor who has last processed the ticket. Also I would like to use only formula tool(If else) to get the output.

Can anyone help....

Input :

Ticket	Processor	Date
123	ABC	6/25/2023
123	ABC	6/25/2023
123	DEF	6/26/2023
126	ABC	5/1/2023
126	ABC	5/21/2023
126	ABC	5/25/2023
126	GHI	6/25/2023
130	ABC	5/1/2023
130	ABC	5/21/2023
130	ABC	5/25/2023
130	DEF	6/25/2023
135	GHI	5/25/2023
135	GHI	5/27/2023
135	GHI	5/25/2023
135	ABC	5/25/2023
135	ABC	5/25/2023
135	DEF	5/25/2023

Output:

Ticket	Processor	Date	Last Processor
123	ABC	6/25/2023	DEF
123	ABC	6/25/2023	DEF
123	DEF	6/26/2023	DEF
126	ABC	5/1/2023	GHI
126	ABC	5/21/2023	GHI
126	ABC	5/25/2023	GHI
126	GHI	6/25/2023	GHI
130	ABC	5/1/2023	DEF
130	ABC	5/21/2023	DEF
130	ABC	5/25/2023	DEF
130	DEF	6/25/2023	DEF
135	GHI	5/25/2023	GHI
135	GHI	5/27/2023	GHI
135	GHI	5/25/2023	GHI
135	ABC	5/25/2023	GHI
135	ABC	5/25/2023	GHI
135	DEF	5/25/2023	GHI

[geraldo · Accepted solution]

@Saravanan13 

An workflow example

[BonusCup]

You will need to convert your Date field to a correct date format.  You can then sort by ticket ascending and the new date field descending.  Use the Sample tool to take the first Ticket row and then join that back to your original data using Ticket.  Sort again by Ticket ascending and the new date field ascending and then use Select to get rid  of the extra fields.

 

[hlee36 · Accepted solution]

Attached is my approach.

I mainly used Tile, Summarize and Join tool.