LinQ to group by with two columns and count

[Krithi1]

Hi,

I have a scenario where I have to group by “ColumnC” and “ColumnD” and then get the count for those each distinct groups. Can someone provide me a linQ query? I can create logically, but it might be good to write a linQ than writing pages of UiPath code.

I need something like

Monday ------ 8.30 am ------5
Monday-------9.30 am -------4
Monday -------11.00 am -------10
Tuesday-------8.30 am ------6
Tuesday------- 11.30 am -------- 8
Wednesday---------9.30 am -------15
Wednesday --------11.30 am -------2

etc

[ppr (Peter Preuss)]

prepare an empty datatable with 3 cols: Day, Time, Count - w.g. with Build DataTable - dtResult

Assign Activity:
dtResult =

(From d in yourOriginDataTable.AsEnumerable
Group d by k1=d("Col1Name").toString.Trim, k2=d("Col2Name").toString.Trim into grp=Group
Let ra = new Object(){k1,k2, grp.Count}
Select r = dtResult.Rows.Add(ra)).CopyToDataTable

[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…

In case that the Timing needs a more detail analysis have a look here for some debugging / analysis techniques:

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[Krithi1]

Hi @ppr This is how It’s printing. Seems like I am declaring the counter incorrectly. I declared it outside of the assign

[ppr (Peter Preuss)]

check for the corrected typo:
Let ra = new Object(){k1,k2, grp.Count}

[Krithi1]

@ppr

{k1,k2, grp.Count}

Thank you very much, it worked!

[ppr (Peter Preuss)]

@Krithi1

Thank you very much, it worked!

Perfect, so we would like to ask you for closing the topic as described here:

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…