It worked for certain cases but please see the following For the following data records, ABC,F, 04/24/2025 15:30:03 ABC, R, 04/24/2025 15:15:01 ABC, F, 04/25/2025 15:50:00 ABC, R, 04/25/2025 15...
See more...
It worked for certain cases but please see the following For the following data records, ABC,F, 04/24/2025 15:30:03 ABC, R, 04/24/2025 15:15:01 ABC, F, 04/25/2025 15:50:00 ABC, R, 04/25/2025 15:25:00 The solution should be as follows - i.e. latest status by day has to be captured. ABC,F, 04/24/2025 15:30:03 ABC, F, 04/25/2025 15:50:00