Thanks RDawson9 for your response. I would prefer to use Loop stage based on your suggestion. In the above example, since I would givel MS Excel input with the above values, I will add the value for John Doe(200+100+300)= 600 and place it in collection. The 600 value needs to be sent by login to...
Hi
I have excel file that has primary key of customer id and other columns. I need to add the dollar amount for each unique customer id using Blue prism.
I would like to get sum of dollar amount for each unique customer id. For customer id : 101, dollar amount should be (200+100+300) = 600...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.