I have the below data. Notice that there are multiple similar steps performed by one or multiple people. I want to retain only the highest / most recent activity, denoted by timestamp. How do I do in Alteryx please?
<table>
<tbody>
<tr>
<td>ID</td>
<td>Step</td>
<td>performed by</td>
<td>Date Timestamp</td>
</tr>
<tr>
<td>123</td>
<td>Submitted for review</td>
<td>UserA</td>
<td>6/6/2024 10:07</td>
</tr>
<tr>
<td>123</td>
<td>Submitted for review</td>
<td>UserA</td>
<td>6/6/2024 10:12</td>
</tr>
<tr>
<td>123</td>
<td>Submitted for review</td>
<td>UserB</td>
<td>6/6/2024 10:34</td>
</tr>
<tr>
<td>123</td>
<td>Reviewed</td>
<td>UserC</td>
<td>6/6/2024 11:27</td>
</tr>
<tr>
<td>456</td>
<td>Input into the system</td>
<td>UserA</td>
<td>5/6/2023 9:07</td>
</tr>
<tr>
<td>456</td>
<td>Submitted for review</td>
<td>UserB</td>
<td>5/6/2023 9:13</td>
</tr>
<tr>
<td>456</td>
<td>Submitted for review</td>
<td>UserB</td>
<td>5/6/2023 9:22</td>
</tr>
<tr>
<td>456</td>
<td>Submitted for review</td>
<td>UserC</td>
<td>5/6/2023 9:37</td>
</tr>
<tr>
<td>456</td>
<td>Submitted for review</td>
<td>UserC</td>
<td>5/6/2023 9:43</td>
</tr>
<tr>
<td>456</td>
<td>Reviewed</td>
<td>UserD</td>
<td>5/6/2023 9:52</td>
</tr>
</tbody>
</table>
Output
Order ID Step performed by Date Timestamp
123 Submitted for review UserB 6/6/2024 10:34
123 Reviewed UserC 6/6/2024 11:27
456 Input into the system UserA 5/6/2023 9:07
456 Submitted for review UserC 5/6/2023 9:43
456 Reviewed UserD 5/6/2023 9:52
Solved! Go to Solution.
@bramaswamy take a look at the attached workflow, does this help? Let me know how you get on
Perfect - thank you aatlai