How to compare excel row by row comparison and view other excel sheet column output

Help Studio
1
  1. Take the file Chart number and compare it to see if there is a duplicate in next row.
  2. If it is duplicate, the patient payment (E) of both are added (+) Patient amount
    (F) column and also remove duplicate nonprint F ( Patient amount) row.
  3. Otherwise, the single value is put in the same F column.

image
image1347×315 8.9 KB

2
  1. The excel sheet should be as shown below. There should be a completed Patient amount column.
  2. FINALLY I need to look new excel sheet into this output.

image
image1462×554 22.2 KB

*** What I want is a workflow that goes with use of the ACTIVITY.

3

Hi @Nikky_Diss ,

It looks like the case of Group By and Sum. There are similar posts already available, do check it and let us know if you still require more help :

1 Like
4

Yeah, but I want use activity to create that workflow. And also need to remove duplicate 1st row.

5

Hi @Nikky_Diss ,
You can use 2 loop to compare data, if chartnumber are match then calculate sum of payment then assign to value of amount
then write data to sheet2
if you need detail, can you share your file?
regards,
LNV

6

Hi,

How about the following?

image
image1417×2547 200 KB

Sample20230814-3L (2).zip (13.1 KB)

Regards,