In Excel i had a column Daily Work Report Name now i had to found how many DWR associated with same WorkOrder and i want to put the count in one column either just after Daily Work Report Name or in end and after then i want to delete the duplicate work order number.
Help me using UiPath code.
Excel is attached.
OPEN DWRS - EV INTERNAL-Local.xlsx (66.1 KB)
Hey @Puneet_Singh1 ,
Refer below file
It will delete the rows which are duplicate work order number
Forum.zip (86.3 KB)
Hope it helps you out!
DWR Count is not getting updated in total column. I mean how many DWR associated with word order. Like
| DWR-3967595 | WO-01784005 | Corrective | 1784005 | Electrify America - Stanford Shopping Center | PM Approved | 6/26/2023 6:13 AM | 6/22/2023 | In Progress | Job Complete | Jacob Sanchez | Michael LeBoeuf | 6/26/2023 | CA | Electrify America (Pearce) | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DWR-3967717 | WO-01784005 | Corrective | 1784005 | Electrify America - Stanford Shopping Center | PM Approved | 6/26/2023 6:31 AM | 6/21/2023 | In Progress | More Time Required | Jacob Sanchez | Michael LeBoeuf | 6/26/2023 | CA | Electrify America (Pearce) |
In this case 2 DWR associated with single work order i mean work order is same for different DWR.
Hello please look into the problem. Help me in this.