Hi, I am try to get the most recent value and search for specific status item itemdesc _time status ITEM01 COKE 2021-09-21 22:00:05 FAILED ITEM01 COKE 2021-09-20 13:00:15 FAILED ITEM02 COKE 2021-09-21 21:00:12 PASSED ITEM02 COKE 2021-09-21 20:00:05 PASSED ITEM02 COKE 2021-09-21 19:00:05 FAILED ITEM03 COKE 2021-09-20 12:00:05 FAILED ITEM03 COKE 2021-09-19 11:00:15 PASSED Need to check most recent status by item, and pull only if status = Failed O/p ITEM01 COKE 2021-09-21 22:00:05 FAILED ITEM03 COKE 2021-09-20 12:00:05 FAILED In this case ITEM02 is ignored since most recent status is PASSED
... View more