How to Sum and Group By multiple rows data from LINQ in Uipath
In this video we have taken example of Employee working hours.
Bot calculated total number of hours employee spend and put result accordingly in excel file.
LINQ Query Used in Video:
IEnum = (From p In dtSheet1.AsEnumerable() Group p By obj_p= New With {Key.P_Employee=p.Item("Employee"),Key.P_Department=p.Item("Department")} Into MG= Group Select new with { .Employee=obj_p.P_Employee,.Department=obj_p.P_Department,.WorkingHours=MG.Sum(Function( r ) Double.Parse(r.Item("WorkingHours").ToString()))}).ToList
strResult = String.Join(",",IEnum(0).ToString.Split(","c).Select(Function(item) item.ToString.Split("="c)(0).Replace("{","").Trim))+System.Environment.NewLine+ String.Join(System.Environment.NewLine,IEnum.Select(Function(row) String.Join(",",row.ToString.Split(","c).Select(Function(item) item.ToString.Split("="c)(1).Replace("}","").Trim.ToString))))
Fore more videos please Subscribe our channel.
Also follow us on:
Facebook Page : / uipathtutorials
Instagram Page : / uipathtutorial
LinkedIn Page: / uipathtutorials
Twitter: / uipathtutorials
HARE KRISHNA 🙏
