I want to count the number of issues resolved by each person from the excel file and also the time difference
and want these data to write in another excel file
I want to count the number of issues resolved by each person from the excel file and also the time difference
So in simple you want to say that below img data you want into another excel Right ??
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
Best Regards
Er Pratik Wavhal
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
I have to calculate it from first and then write into other excel file.
Can you share us the sample xlsx file with the date and time as shown above?
Thanks
I have made the complete workflow for the same which gives perfect output that you are in search of
So Below is the workflow for the same.
Vishal Jyoti.zip (16.0 KB)
Output :-
Mark as solution and like it
Happy Automation
Best Regards
Er Pratik Wavhal
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:
I didn’t got any error at my side. Where did you got this error means at which step ??
Happy Automation
Best Regards
Er Pratik Wavhal
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.
Thats Great the error got resolve. Gud.
Glad to hear that my solution help you.
You are welcome
Happy Automation
Best Regards
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.