I have many IDs, I need to get the sum of "Total hours" column that has the same IDs then write it to another excel file with sheets that has the same IDs

Help Studio
1

Sample : INPUT
uipath

OUTPUT:

image
image290Ɨ509 3.62 KB

image
image
image267Ɨ515 2.48 KB

2

Thank you in advance.

3

@Ogigi Can you provide the Sample Input File? It will be easier to find a Solution if you provide it :sweat_smile:

4

sorry, Iā€™m just a new user, it says that I cannot upload attachments

5

@Ogigi Check this Workflow :
GroupByAndSum.zip (9.9 KB)

1 Like
6

@Ogigi
find demo XAML that is merging the tasks from this post with your other post
Ogigi_2.xaml (15.9 KB)

2 Likes
7

@ppr it is creating new sheets, I already have sheet names named after their IDs, then I just need to get their total hours and paste it in their respective sheet name.

8

for example, the ID is 123, I need to get the total hours of ID-123, then paste in the sheet named ā€œ123ā€ then same with all the IDs. Thank you

9

@Ogigi
Had you rewire the output Excel path to your Excel path? It is creating new scheets, if this sheet does not exists

Also take note on this setting:
grafik

For the dynamics I would suggest to let create the missing sheets by the bots

10

Can it create the sheet that is missing? because the sheets needs to be equivalent to the IDs

11

the sheetname will be the id and will be created if it does not exist. Just play a little bit with it and delete one sheet, change an ID ā€¦

12

mine just creates new sheets with the sheet name equivalent to the total hours

13

can you share a screenshot from your xaml on this part? Thanks

15

here it is, thanks
image
image

image
image489Ɨ514 11.8 KB

16

@supermanPunch what if I want only the total and write it in a specific cell, what will I remove from the code?

17

Topic is forked to