Im very new in UI Path im facing a error , to create an automation . my requirement is browse a excel file and pulling unique value using for each loop and eliminate duplicate .any help appreciated.
now
it Should be
Im very new in UI Path im facing a error , to create an automation . my requirement is browse a excel file and pulling unique value using for each loop and eliminate duplicate .any help appreciated.
now
it Should be
Hi @Sayantan,
Read the xl into a Datatable. Please the refer the below link procedure.
" ListA=(From p In dta.Select()
Group p By ID=p.Item(“ID”).ToString Into GroupA=Group
Select Convert.ToString(GroupA.Sum(Function(x) Convert.ToDouble(x.Item(“Amount”).ToString)))).ToList() "
Above code will solve your problem.
Regards
Balamurugan