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
Similarly for customer 201, it should be (200+50+ 200)= 450 etc. The input file is excel as specified and i need to store the sum of dollar amount using Blue prism.
Any help would be appreciated. Do i need to use loop stage or using code stage?
Example:
S no Customer ID Fname Lname Dollar amount Memo Transaction no
1 101 John Doe 200 1 501
2 101 John Doe 100 1 502
3 101 John Doe 300 1 503
4 201 Sam Doe 200 1 201
5 201 Sam Doe 50 1 241
6 201 Sam Doe 200 1 233
7 241 Liz Simmon 50 0 801
8 241 Liz Simmon 50 0 801
9 251 Charlie Jones 10 6 751
10 251 Charlie Jones 20 7 752
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
Similarly for customer 201, it should be (200+50+ 200)= 450 etc. The input file is excel as specified and i need to store the sum of dollar amount using Blue prism.
Any help would be appreciated. Do i need to use loop stage or using code stage?
Example:
S no Customer ID Fname Lname Dollar amount Memo Transaction no
1 101 John Doe 200 1 501
2 101 John Doe 100 1 502
3 101 John Doe 300 1 503
4 201 Sam Doe 200 1 201
5 201 Sam Doe 50 1 241
6 201 Sam Doe 200 1 233
7 241 Liz Simmon 50 0 801
8 241 Liz Simmon 50 0 801
9 251 Charlie Jones 10 6 751
10 251 Charlie Jones 20 7 752