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

image

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

Fine
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
Cheers @ROBERT_RUSSELL_MONSA

3 Likes

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

image

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

This expression in a ASSIGN activity will give that count
Cheers @ROBERT_RUSSELL_MONSA

1 Like

So I didn’t need to use For Each?

No buddy
@ROBERT_RUSSELL_MONSA

image

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
Cheers @ROBERT_RUSSELL_MONSA

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
int_count=variable.select(absence type=“Absence”).count

image

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()

Cheers @ROBERT_RUSSELL_MONSA

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.