Hi @balu
Steps
1.use read range activity for excel and gv datatable
2.use for each row in dt
3.use calculator app
4.check the if condition as row(“column name”).Tostring.contains (“sa”) type the row value of in calculator perform the manipulation
5.store the result using copy selected text
6.use write range to store the result in excel
Declaration
DataTable Variable as dta (this points to excel as DT)
Dictionary(Of string, Of string) as Dictionary how to create this??
System.Collections.Generic.Dictionary<TKey, TValue> is these the one …
@balu
First Read your Excel sheet by using ReadRange activity and strore it in a datatable variable dta
Then go to variables section on the bottom of the uipath
create a variable Dictionary
Click on the Corresponding DataType Column cell and Then click on Browse for more DataTypes
Then Type Dictionary in the search field
Select System.Collections.Generic.Dictionary
Then Select String for Key and String for Value.
Then Click on ok
Then Use one Assign Activity
Dictionarty=( From p in dta.Select
group p by Department=p.Item("DEPARTMENT") Into GroupA=Group
Select GroupA).ToDictionary(Function(x) x(0)("DEPARTMENT").ToString, Function(x) Convert.ToString(x.Sum(Function(y) Convert.ToDouble(y.Item("Work HR").ToString))))