Data table - combine and keep most recent

Help Community
,
6

so instead of adding a date i added a counter that will increment everytime the job runs. i also changed ID to employee ID.

The image shows a spreadsheet with multiple tables of employee sales data from different runs, with a final consolidated table summarizing the sales from each run. (Captioned by AI)
The image shows a spreadsheet with multiple tables of employee sales data from different runs, with a final consolidated table summarizing the sales from each run. (Captioned by AI)611×744 13 KB

Still not certain how to get the max run id per employee id though

updated txtx \ csv files attached
Updated DT_1.txt (71 Bytes)
Updated DT_2.txt (70 Bytes)
Updated DT_3.txt (58 Bytes)