How to Count the data of one column in data table w.r.t other column?

[Sumanth_Reddy1 (Sumanth Reddy)]

Hi team,

Use Case: I’m calculating the Hire Date of employees across different sites in US .

In one column I have Site Names Like DAE4 ( something like this), in Other column I’ve Employee ID’s for that particular site who Hire Date is processed as successful in Queueitem( Status: Successful).

In addition to this, I need count of no.of employee ID’s wr.t each site

Like Column 1: Site Name
Column 2: No.of employee’s whose hire date is processed.

How can I achieve this ? I’m using RE Frame Work

[TimK (Tim Kok)]

Without more information, it sounds like you want to simply find how many employees are hired at each site?

FILTER AND COUNT WITH LINQ

the dictionary approach: dictCValCount | Dictionary(Of String, Int32) = (From d in dtData.asEnumerable Group d by k=d(“C”).toString.Trim into grp=Group Select t= Tuple.Create(k, grp.Count)).ToDictionary(Function (x) x.Item1, Function (x) x.Item2) With a prepared datatable, having 2 cols, Key, Count - dtStatistic we can do: dtStatistic = (From d in dtData.asEnumerable Group d by k=d(“C”).toString.Trim into grp=Group Let ra = new Object(){k, grp.Count} Select r= dtStatistic.Rows.Add(ra))…

You could look at using something like this?

[muhammedyuzuak]

Hi @Sumanth_Reddy1,

Can you share an example table? I’m sure you’ll get more suggestions if you share sample inputs and the output you expect.

Regards,
MY

[Sumanth_Reddy1 (Sumanth Reddy)]

This is the data table where Queue Values were stored. Now, I need the data in the following format in excel file