LIN

[Shaik_Ahmed1 (Shaik Ahmed)]

HI All
How to Group And Count using LINQ Query For Example: I have one column with country names & I want another column with count of each country after group by using LINQ how can we achieve that

Appreciate response
Thanks
Shaik Ahmed

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Shaik_Ahmed1
please check this one
GetGroupCountResultStatistic_2Keys.xaml (8.2 KB)

[ppr (Peter Preuss)]

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

[ppr (Peter Preuss)]

In addition to:

@raja.arslankhan

@Shaik_Ahmed1
please check this one
GetGroupCountResultStatistic_2Keys.xaml (8.2 KB)

Find Link to the original topic:

Group By Aggregation Count

@khcs0710 Find starter Help here: GetGroupCountResultStatistic_2Keys.xaml (8.2 KB)

[Suraj_B_Shetty (Suraj)]

Hi @Shaik_Ahmed1

Give a try to this

Sample Workflow
GroupByCount.xaml (7.5 KB)

[fernando_zuluaga]

Hi @Shaik_Ahmed1

Welcome to our community,

in this forum are lot of examples that you can search, if you have any particular query we may help you, otherwise you can search for examples like @ppr shared above and this one

How to sum up the Amount of Dublicate Id's in Data table In Linq

Hi @adarsh_kotagiri wha about the following? [image] (From row In dtInput.AsEnumerable Group row By sc = row("ID").ToString() Into grp = Group Let totalGross= grp.sum(Function (x) Convert.ToDouble(x("GROSS").ToString())) Let totalNet= grp.sum(Function (x) Convert.ToDouble(x("NET").ToString())) Let result = New Object() {grp(0)("ID"),totalGross, totalNet} Select dtToWrite.rows.add(result)).CopyToDataTable [image] Regards

Regards!