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