Hi, Could you please help me with this? I have a data table like this. id Name Account RegDate ExpDate f01 Jhon 1 01/01/2022 31/01/2022 f01 Jhon 2 30/09/2021 30/09/2022 f02 Paula 1 01/01/2022 31/01/2022 f03 Matt 1 01/01/2022 31/01/2022 f04 Jane 1 15/06/2022 15/06/2021 f04 Jane 2 01/01/2022…

[grafik] [grafik] (From d In dtData.AsEnumerable Group d By k=d(0).toString.Trim Into grp = Group Let maxMember = grp.OrderBy(Function (x) DateTime.ParseExact(x("ExpDate").toString.Trim, "dd/MM/yyyy", CultureInfo.InvariantCulture)).Last() Select r=maxMember).CopyToDataTable we do ordering the gro…

you need additional to filter the group members of each group to get the row with max ExpDate

Sorry I do not get it. What do you mean for additional filter? Thaks for the answe

in your LINQ: Let md = grp.Max(Function (d) d(3)) it tries to calculate the max date, but it is not filtering the group member rows for the latest date [image] Paola_58: id Name Account RegDate ExpDate f01 Jhon 1 01/01/2022 31/01/2022 f02 Paula 1 01/01/2022 31/01/2022 f03 Matt 1 01/01/2022…

Hi, thanks for helping. I’ve tried some other linq expressions, taken from vb.net documentation but they don’t work on Uipath, very likely I am doing some mistake. Generally speaking, I need to learn How to Group a table using a certain field and do a certain number of operations on the group. Lik…

currently i was searching your topic. will have a look later on it and check for a starter help XAML.

For learnings have a starter help here: [image] [HowTo] LINQ (VB.Net) Learning Catalogue Tutorials This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First St…

[image] ppr: (From d In dtData.AsEnumerable Group d By k=d(0).toString.Trim Into grp = Group Let maxMember = grp.OrderBy(Function (x) DateTime.ParseExact(x("ExpDate").toString.Trim, "dd/MM/yyyy", CultureInfo.InvariantCulture)).Last() Select r=maxMember).CopyToDataTable It Works! Thanks very m…

Datatable select record grouped by id based on field data

Help Studio

ppr (Peter Preuss) February 8, 2022, 10:50am 8

For learnings have a starter help here:

Topic		Replies	Views
Grouping data table and select rows with Max date Community question , community	2	2416	May 6, 2022
Data table Aggregation for dates Studio studio , question , activities_panel	7	3013	March 17, 2021
How to find the maximum value for an Unique ID using linq Studio studio , question , activities_panel	12	4439	October 7, 2022
How to get value based latest date? Activities uiautomation , activities , question	6	996	July 14, 2022
Group by duplicate ID and take the highest available amount from other columns Help datatable , excel , studio , question	22	4562	May 30, 2021

Datatable select record grouped by id based on field data

Related topics