Help on the Use Case

Help Studio
, ,
1

I want to count the number of issues resolved by each person from the excel file and also the time difference

Capture(1)
Capture(1)1106×114 10.4 KB

and want these data to write in another excel file
Capture(2)
Capture(2)822×226 4.89 KB

1 Like
2

Hi @vishal.jyoti_cs15

So in simple you want to say that below img data you want into another excel Right ??
image

Before that May i know that the data is already present in some excel or you have to calculate it 1st and then want to store in another excel ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

3

I would recommend reading the datatable in, adding an additional column to calculate the individual time taken per row, resolved timestamp - received timestamp and turn into minutes (integer or double)

You can then use LinQ to sum and group based on assignee and new time taken column

See link Linq query for groupby and sum - #3 by GBK for more details for linq

1 Like
4

I have to calculate it from first and then write into other excel file.

5

@vishal.jyoti_cs15

Can you share us the sample xlsx file with the date and time as shown above?

Thanks

6

Yes sure.
Issues-13-07-2020 - Copy - Copy.xlsx (8.4 KB)

7

Hi @vishal.jyoti_cs15

I have made the complete workflow for the same which gives perfect output that you are in search of :slight_smile:

So Below is the workflow for the same.
Vishal Jyoti.zip (16.0 KB)

Output :-
image

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes
8

Thanks for the help.
Everything working perfectly all the entries is written in excel file as per the requirement but at last, after execution, it shows an error:
Capture

9

Hi @vishal.jyoti_cs15

I didn’t got any error at my side. Where did you got this error means at which step ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

10

I figured that actually the error was the DataType of the variable in the last step.
I resolved that and now it’s working fine.
And once again Thank You very much for your help. :blush:

11

Hi @vishal.jyoti_cs15

Thats Great the error got resolve. Gud.
Glad to hear that my solution help you.
You are welcome :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.