“Group” function LINQ Basic

[RajKumar_DC (RajKumar Durai)]

Speed ​​up your work using LinQ

“Group” function LINQ Basic

Code:
(From item In dt.AsEnumerable
Group item By col1 = item(“Column1”).ToString.split(“-”,2,stringsplitoptions.none)(1) Into Group
Select dt.Clone.Rows.Add(col1,Group.sum(Function(x) CInt(x(“Column2”).ToString)))).CopyToDataTable

RajKumar Durai on LinkedIn: For #UiPath Followers

Thanks,

[ppr (Peter Preuss)]

@RajKumar_DC

using LinQ

Get some additional starter help from here:

[HowTo] LINQ (VB.Net) Learning Catalogue

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 Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…