Dictionary with repeat Key and distinct multiple value(Time)

[scorpialee]

datatable==
ID DoTime
A1 2023-08-01 09:13:49
A2 2023-07-31 17:36:28
A3 2023-07-31 17:15:49
A4 2023-07-20 17:54:28
A1 2023-07-20 17:49:33
A2 2023-07-20 17:48:33
A6 2023-07-20 17:43:45
A7 2023-07-20 16:25:49
A8 2023-07-20 16:24:33
A1 2023-07-20 16:06:32

dic=
ID DoTime
A1 2023-08-01 09:13:49
A2 2023-07-31 17:36:28
A3 2023-07-31 17:15:49
A4 2023-07-20 17:54:28
A6 2023-07-20 17:43:45
A7 2023-07-20 16:25:49
A8 2023-07-20 16:24:33

dt.AsEnumerable.ToDictionary(Of String, String)(Function (r) r(0).toString, Function (r) r(1).toString)
That is error，I hope keep lasted DoTime,please help，thanx

[Convert datatable to dictionary with repeating values - Help / Studio - UiPath Community Forum]

[Yoichi]

Hi,

Can you try the following sample?

dict = dt.AsEnumerable.GroupBy(Function(r) r(0).ToString).ToDictionary(Function(g) g.Key,Function(g) g.OrderBy(Function(r) DateTime.Parse(r(1).ToString)).Last().Item(1).ToString)

Sample20230823-3L.zip (8.7 KB)

Regards,