Group By Sort with date col and get First Row off all Group.(Linq)

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi Community,
I have a Datatable and I want to get first row of each group by sorting date column.(Latest should comes first)

Thanks

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Yoichi @ppr

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi Guys,
Is it correct?

(From d In DT.AsEnumerable
Group d By d(“Col1”).ToString.Trim Into grp=Group
Select R=grp.OrderBy(Function (r)DateTime.Parse(r(“Date”).ToString)).First()).CopyToDataTable

[ppr (Peter Preuss)]

We assume that the date vlaues are parseable with DateTime.Parse or others

(From d In DT.AsEnumerable
Group d By d("Col1").ToString.Trim Into grp=Group
Let gro = grp.OrderBy(Function (x)DateTime.Parse(x("Date").ToString.Trim).Ticks) 
Select r=gro.Last()).CopyToDataTable

check also if .Ticks can be omitted
Also, have a look at the OrderByDescending(…) method, but then we would use First()

[ppr (Peter Preuss)]

Cross Reference:

Assign: String '11/1/2022 12:00:11 AM' was not recognized as a valid DateTime

Hello Everyone: I am trying to sort datatable through column which contains data like this and I am getting this Error. [image] I am using query ->(From d In DT.AsEnumerable Group d By d(“Col1”).ToString.Trim Into grp=Group Select R=grp.OrderBy(Function (r) DateTime.ParseExact(r(“Date”).ToString,“dd/MM/yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)).First()).CopyToDataTable

[raja.arslankhan (Raja Muhammad Arslan khan)]

@ppr

(From d In DT.AsEnumerable
Group d By d(“Col1”).ToString.Trim Into grp=Group
Let gro = grp.OrderBy(Function (x)DateTime.Parse(x(“Date”).ToString.Trim).Ticks) 
Select r=gro.Last()).CopyToDataTable

@ppr

I tried your code but it gives this one.

[ppr (Peter Preuss)]

ensure and retype every “ or ” to "

Check always the Quotations when copy paste Code snippets

[raja.arslankhan (Raja Muhammad Arslan khan)]

@ppr
same in your case as well.

[ppr (Peter Preuss)]

@raja.arslankhan

same in your case as well.

Not the same, Compilation error is gone, now the expected format is not matching the constraints of the used conversion method.

We already mentioned:

@ppr

We assume that the date values are parseable with DateTime.Parse or others

and on your other topic linked with the cross-reference, some additional feedback is shared

[raja.arslankhan (Raja Muhammad Arslan khan)]

@ppr
After reading from excel I get this one
→

[ppr (Peter Preuss)]

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

Just check the entire data table on consistent format as described within the FirstAid

[raja.arslankhan (Raja Muhammad Arslan khan)]

@ppr

Problem Solved.Thanks

[ppr (Peter Preuss)]

@raja.arslankhan

Problem Solved.Thanks

Perfect,
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum