Summation of Hours per Employee

Help Activities
, ,
1

Good Day.

image
image891Ă—564 13.6 KB

I have this datatable where it consists a list of employees together with their Employee IDs, Positions, Hours Rendered, and assigned Project Number. I want to find the summation of hours per employee just like the image below. Can I use Filter DataTable activity? Or are there any other activities that can be used? Thank you.

image
image1084Ă—322 11.8 KB

Kindly see attached file for the excel file.

Best regards,
Robert Monsalud
Sample1.xlsx (8.7 KB)

2

we would group the data:

1 Like
3

Thank you for the information. I will take a look on this.

4

Hi @Robert_Russell_Monsalud

As suggested by @ppr, this can be achieved through LINQ. Please refer the below screenshot and workflow files

(
	From row In dt_Data
	Group row By k = row("Employee ID")
	Into grp = Group
	Select dt_Data.LoadDataRow(grp(0).ItemArray.Reverse.Skip(1).Reverse.Append(grp.Sum(Function (gr) CInt(gr("Time Rendered")))).ToArray, True)
).CopyToDataTable

image

SummationOfHoursPerEmployee.xaml (5.6 KB)

2 Likes
5

Thank you so much for sharing the exact solution. May I ask if what are the further steps that I have to do if I will only retain the “Employee ID”, “Employee Name”, and “Time Rendered” column? Thank you.

Best regards,
Robert Monsalud

6

you can use afterwards e.g. filter datatable activity and keep / remove columns

1 Like
7

Hi @Robert_Russell_Monsalud

You can proceed like this

image

(
	From row In dt_Data
	Group row By k = row("Employee ID")
	Into grp = Group
	Select dt_Out.Rows.Add({k, grp(0)("Employee Name"), grp.Sum(Function (gr) CInt(gr("Time Rendered")))})
).CopyToDataTable

XAML for the reference

SummationOfHoursPerEmployee.xaml (7.0 KB)

8

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