I am comparing two columns namely “Customer Service” and “Patient Name”. The Column “Customer Service” contains names which deals with multiple patients in column “Patient Name”. After comparing I want to add count on column “patient name”. And then print count value in “Total Patients”.
Your help will highly be appreciated.
welcome to forum
I am not cleared by your requirement
It would be helpful if you add the screenshots of excel u need to compare
If you need compare two data row from 2 columns, you can use the for each row activitie and you can use the if activitie (use the comparator simbol according that you need):
currentrow.item("Customer Service).tostring = currentrow.item(“Patient Name”).tostring
1- The bot read each row
2 - Compare data with the if activitie getting the data row in each column that you need.
3- If you need a special output use the then or else result to the next process.
Let me know your thougths.