This excel automation is possible…? From below excel screen
The source file is…
Yes you can use filter data table and keep the rows containing SRV-CALL
Then Sort according to “Resouce Name”
Thanks @jcvsalinas, I’m trying it
To achieve the same, I’ll suggest you to follow the steps below.
Use Read Range activity to read excel sheet and create output var for that —> DT
To divide data with respect to Resource & Resource Name, you need to get distinct Resources by using following code in Assign activity,
DistinctResource = DT.DefaultView.ToTable(True,"Resource","Resource Name")
DistinctResource —> DataTable var, will hold all distinct Resources.
Use For Each Row activity to iterate through DistinctResource.
Take Filter Data Table activity inside for each row, to filter DT using each Resource. (As given below)
for Total value, i don’t see anything related from those visible columns, so if there’s a column related to that then, you can use the logic to get the value. So, you can simply use correct Index logic in range for writeline & write range at the end of the for each row.