Error BC30456: 'GroupBy' is not a member of 'EnumerableRowCollection(Of DataRow)'

Help Studio
, ,
1

Hello everyone and here my first UiPath post from an automation learner.

Follwing code was working fine at ends of January… but now when I’ve try to execute again… I obtain…
ManipulateData.xaml: (2) : error BC30456: ‘GroupBy’ is not a member of ‘EnumerableRowCollection(Of DataRow)’.

code inside an Assign activity
in_dtAuxFull.AsEnumerable.GroupBy(Function(r) r(“match”).ToString).SelectMany(Function(g) g.GroupBy(Function(r) DateTIme.Parse(r(“date”).Tostring)).OrderBy(Function(g2) g2.Key).Last()).CopyToDataTable()

This code recover the last date (column 5 - date) for each match stored in_dtAuxFull and store it in another dt (out_dtLastDates)

Obviously my Studio IDE had been upgrade from January… but How can I sove it?
Any ideas?

Regards and happy Sunday.

2

Hi @Ignacio_TFM

First try removing the code and then putting it again in the assing activity, might it is bugged

Make sure to import the linq namespaces

image
image1129×89 2.45 KB

if none of the above works, here is another approeach

(From r In in_dtAuxFull.AsEnumerable()
Group r By match = r("match").ToString() Into Group
From g In Group
Group g By DateToOrder = DateTime.Parse(g("date").ToString()) Into DateGroup = Group
Order By DateToOrder
Select DateGroup.Last()).CopyToDataTable()

Regards!