Count Same transaction item

[Gokul_Murali]

Hello guys i have an excel with column and data

Here i want to calculate same data ie,

P-100-7101-2020-3 = 2
P-100-7101-2022-100 = 1
P-100-7101-2022-245 = 3
i need the value to enter it in a field. (Using RE Framework for this process)

does anyone have the idea

[rikulsilva (Henrique Lima da Silva)]

Hi

Take I look here

How to get count of duplicate data in a excel using LINQ query in uipath

Hi Team, I have one excel with bulk data . I have account number column there in excel .so, how to get count of duplicate account number in excel using LINQ query in UiPath. The count should be int variable . Please suggest Thanks, Baby

[Gokul_Murali]

I want to call the total number while processing each transaction data, means

if iam processing " P-100-7101-2020-3" it should return 2.

Can we do like that

[Gokul_Murali]

@Anil_G
@Rahul_Unnikrishnan

Can you help me out on this

[ppr (Peter Preuss)]

WE can doit by grouping the Data and counting the group members

[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)]

@Gokul_Murali

Can you help me out on this

As already presented

@ppr

dtResult = new configured datatable with 2 cols / dtOrig clone
dtResult =

(From d In dtData.AsEnumerable
Group d By k= d("YourKey").toString.Trim Into grp=Group
Let c = grp.Count
Let ra = New Object(){k,c}
Select dtResult.Rows.Add(ra)).CopyToDataTable

dtData = your Origin DataTable Variable
YourKey = we assume "Policy Reference"

Otherwise it is a filter case or we can filter the prepared GroupBy Count Result

[Anil_G (Anil Gorthi)]

@Gokul_Murali

in the proces.xaml i hope you are getting the Policy Reference

dt.AsEnumerable.Where(function(x) x("Policy Reference").ToString.Equals(TransactionItem("Policy Reference").ToString)).Count

cheers