Specify the sum of repeated comments in Column

[aleksandra.plichta5 (Aleksandra Plichta)]

Hi,
I have Data Table with “Comment” column at the end.
There can be differenet values.
I would like to have sum up:
10x Comment1
5x Comment2
3x Comment3
1x Comment4

How can I do that?

[Anil_G (Anil Gorthi)]

@aleksandra.plichta5

Please try this in assign activity and first use build datatable(dtsum) and add two columns of type string

DtSum = (From d In dt.AsEnumerable() Group d By k=d("Comments").toString.Trim Into grp = Group Let coun = grp.count.ToString Let ra = New Object(){k,coun} Select r = DTSum.Rows.Add(ra)).CopyToDataTable()

Dt is the input datatable
Dtsum Is the output with two columsn one is comment and other is count both as strings
Comments is the column name can change as per your input

Cheers

[ppr (Peter)]

we can do it by grouping the data

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

e.g a LookUp Dictionary

Assign Activity:
myLKDict | Dictionary(Of String, int32) =

YourDataTableVar.AsEnumerable.GroupBy(Function (x) x("Comment").toString.Trim.).ToDictionary(Function (g) g.Key, Function (g) g.Count)