Stuck to create a summary data from excel

excel

#1

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
image

it Should be
image


#2

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


#3

Thank You @balupad14 :slight_smile:


#4

Hi @Sayantan,
Try this with less code.

Regards
Balamurugan