How to group data in Excel?

[cybzom (Kiran Saminathan)]

I have an excel that looks like this:

A 4
B 5
C 6
A 1
C 1
A 6

I want to group the data and give an output like

A total
B total
C total

Kindly help…

[cybzom (Kiran Saminathan)]

@arivu96 can u help me this this one??

[Srini84 (Srinivas Kadamati)]

Hi,

Refer this

Get total count of data based on group by condition in Datatable

Hi, I am having a datatable like this: Id Name Result 1 MyApp1 Pass 1 MyApp1 Fail 2 MyApp1 Pass 2 MyApp2 Fail 5 MyApp2 Fail I need to extract three informations out here Id Name and total number of Pass/Fail in this case: O/p is Id Name Total Number of Pass case 1 MyApp 1 2 MyApp1 2 Basically group by records based on ID here

Hope this may helps you

Thanks

[cybzom (Kiran Saminathan)]

Hi @Srini84 this is not exactly what i wanted to achieve… as u can see the question just filters based on pass or fail but here i want to group based on the name so if there are 10 A’s and each has one value, i need an output like A [total sum of all other A’s]

i’m also trying alternate ways by myself but i’m a newbie so that’s y i posted to this forum…

thnx…

[KarthikByggari]

Please use the LINQ query to get the work done. I have tested and working fine.

Please find the C# linq query. You can convert to VB.Net code.
Replace Column1 and Column2 in the below code.

DataTable newDt = dt.AsEnumerable()
              .GroupBy(r => r.Field<String>("Column1"))
              .Select(g =>
              {
                  var row1 = dt.NewRow();
                  row1["Column1"] = g.Key;
                  row1["Column2"] = g.Sum(r => r.Field<int>("Column2"));
                  return row1;
              }).CopyToDataTable();

Regards,
Karthik Byggari

[Lahiru.Fernando]

Hey @cybzom

You can also use the below custom activity to group the data in the datatable…

Use the consolidate Datatable activity which is bundled in this. You can also find a user guide in the component itself so that you can easily configure it.
https://go.uipath.com/component/datatable-plugins

[samir (Samir Mohite)]

Hi @cybzom,

Check this thread, this will definitely helps you.

Excel Sum and deletion of duplicates

hi @lilo hope this will help you, here’s my workflow: groupBysum.xaml (11.8 KB) dataTable: [dt1] O/P: [dtOp]

[ppr (Peter Preuss)]

Direct Link to Post with solution ist Here

Identify the Duplicates and sum the value

Hi, 1.I need to find the duplicate value in the “ID” column. so value 80 and 82 contains duplicates. From that i need to compare “key” column.If duplicate is there in the key column then i need to sum all the columns value. In this case 82 column as duplicate ID and also key column contains duplicate key so i need to sum and bring the value as [image] Input:test.xlsx (9.4 KB) [image] I need to find duplicate for ID and key column.if duplicates ID contains duplicate key.Then i need to sum…

[HareeshMR (Hareesh Madasi)]

How about pivoting the data in excel @cybzom ?

[nanda_kishore]

In one excel sheet out of 10 columns i need to do these duplicates and sum in only 2 columns what about remaining 8 columns when printing

[saisree_bollam]

in this what is meaning of p

[ppr (Peter Preuss)]

@saisree_bollam
welcome to the forum

@saisree_bollam

in this what is meaning of p

p is refering to the current looped datarow

Find some starter help on LINQ here:

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

[saisree_bollam]

hi Thanks for ur reply…I have one doubt in reframe work with out queus workflow. In that I want to combine different excel data by match and mismatch status. In get transaction I have to use string type variable for transaction item and array of string for transaction data but i am getting error whn i run the file .

please check

[saisree_bollam]

I have different excel fileslike this and in that 2 diffrent data is available and i have to check status of the 2 files … and I have to read total data