Sum col4 data of excel according to the col2 names and write in col5

[ankur_kaushik2 (ankur kaushik)]

IN ss there is Country names and price ,so use case is we have to write the sum of price according to country names and write in col 5 where marked green,
Similarly for another country total count upto france and write the total in col5 .

Please suggest me how can i resolve it.

[lrtetala (Lakshman Reddy)]

Hi @ankur_kaushik2

The following thread might be help for you

Linq query for groupby and sum

@Sugumar8785 - pls try below - Build a datatable with same format and data → name as dtData dtResults = dtData.Clone dtResults = (From dte In dtTable.AsEnumerable Group dte By col1=dte(2).ToString.Trim Into Group Select dtResults.Rows.Add({col1, Group.Sum(Function (x) CInt(x(1).toString.Trim))})).CopyToDataTable you can get the same output Col1 – Col2 AA – 55 RT – 27 HL – 37 let me know if you find an issues…

Regards,

[pravallikapaluri]

Hi @ankur_kaushik2
1.Use the “Excel Application Scope” activity
2.Read the Excel file
3.For Each Row activity to loop through each row in the Excel file.
Create a variable called “total” and initialize it to 0 before the loop.
Use the following expression inside the “Assign” activity: total = total +
Convert.ToDouble(row(“Price”))
This will add the price value of each row to the total.
4.use another “For Each Row” activity to loop through the data table again.
use an “Assign” activity to write the total sum for each country in the fifth column of the
corresponding row. You can use the “Write Cell” activity
5.Use “Write Range” activity

Hope it helps!!