Identifying if an employee commits absences and his/her number of absences


What should I do to identify if an employee commits absences and his/her number of absences?

To check the count of absence or
To get the number of absence based on this column
int_count = datatable.Select(“[yourcolumnname] = ‘Absence’ “).Count

Where int_count is a variable of type int32 defined in the variable panel


Thank you very much, Sir. I will work on this.

Sir @Palaniyappan should I use For Each?

May i know for what @ROBERT_RUSSELL_MONSA

1 Like


For this column. To know if there are absences and the number of absences.

This expression in a ASSIGN activity will give that count

1 Like

So I didn’t need to use For Each?

No buddy


Thank you but it has an error.

you have to read entire sheet

But all I need is to read the entire column only.

Get us to that blue mark in that assign activity so that we can find what is the error

first we can read the entire sheet then we have to select the perticular column

first data from excel and save (variable)
use assing activity type=“Absence”).count


That’s the error. I’m sorry if I ask too many questions. I’m just new in using UIPath.

—use excel application scope and pass the file path as input
—inside scope use READ RANGE activity and get the output with a variable of type datatable named dt
—now use this assign activity and mention like this
int_rowcount = dt.Select(“ [”Attendance Type] = ‘Absence’ “).CopyToDatatable()


1 Like

Main.xaml (5.9 KB) project.json (918 Bytes)

1 Like

@Palaniyappan Thank you so much.

1 Like

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