Hi,
I have an excel it contains days, excel hours, punch hours and difference of 2 workers(2 different sheet I want to make it as an consolidated excel by providing total no of working days, leave, weekend and Holidays and work from home .How to get the count of these.
can anyone please help me to find the count of these.
Use read range activity to read excel data and store data in datatable variable.
To get the count of datatable:
Use Datatable_Name.Rows.Count
You Get the count.
Hope This will Help you.
Thank you
Hi,
The requirement is to get the count of Leave, Holiday, WorkingDay.
And what is your expected output like how it should be looking or where it should be stored??
It has to store in the excel
Employee name, workingday, Leave, Holiday, Work from home.
Hi,
Check this workflow and outputs:
Attendance Tracker.xaml (20.7 KB)
AttendanceData.xlsx (10.8 KB)
Consolidated Data.xlsx (7.2 KB)
I have used different filters on your last column which says whether its weekend or leave or workfromhome.
And used RowCount of different DataTables to get the desired result.
This would be working pretty fast and easy to understand solution.
Hi @Chippy_Kolot ,
Create 4 variables to keep the count of the each activity(leave , working day , WFH and weekend) , then use read range activity to get excel data. Then loop it for each row and increase the count respective variable whichever comes in the current row. For example , if current row have weekend then increase the count of weekend variable. Finally you can write these variable into the excel to have considated report.
Use the “Filter Data Table” activity to filter the data table based on the criteria you need. For example, you can filter based on the “Type” column to separate working days, leaves, weekends, holidays, and work from home.
Use the “Get Row Item” activity to retrieve the count of each filtered data table.
Thanks!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.