How to load the latest date & time and the relevant data?

[My_Rebecca]

As asked, I need to load the relevant data of latest date & time. How to realize it in script or expression? 

Date	Time	Average daily GR line in previous 3 months	Forecast Total GR Line	Forecast Total GR Piece Count	Actual Total GR Line	Actual Total GR Piece Count
2023-05-22	10:11:12 AM	3,003	2,379	518,687	2,291	34,787
2023-05-22	13:11:12 AM	3,003	2,381	518,689	2,291	34,787
2023-05-21	18:11:12 AM	3,003	2,383	518,691	2,291	34,787
2023-05-21	15:11:12 AM	3,003	2,385	518,693	2,291	34,787

[BrunPierre]

Hi, Try this.

Data:
LOAD Date,
Time,
TimeStamp(Date#(Date, 'YYYY-MM-DD') + Time#(Time, 'hh:mm:ss TT'), 'YYYY-MM-DD hh:mm:ss') as Timestamp
[Average daily GR line in previous 3 months],
[Forecast Total GR Line],
[Forecast Total GR Piece Count],
[Actual Total GR Line],
[Actual Total GR Piece Count],

FROM SourceTable;

Inner Join
LOAD Date,
Time,
TimeStamp(Max(Timestamp)) as Timestamp
Resident Data

Group By Date, Time;