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

Help
, ,
#1

image

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

#2

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
#3

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

#4

Sir @Palaniyappan should I use For Each?

#5

May i know for what @ROBERT_RUSSELL_MONSA

1 Like
#6

image

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

#7

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

1 Like
#8

So I didnā€™t need to use For Each?

#9

No buddy
@ROBERT_RUSSELL_MONSA

#10

image

Thank you but it has an error.

#11

you have to read entire sheet

#12

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

#13

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

#14

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

#15

first data from excel and save (variable)
use assing activity
int_count=variable.select(absence type=ā€œAbsenceā€).count

#16

image

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

#17

ā€”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
#18

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

1 Like
#19

@Palaniyappan Thank you so much.

1 Like
#20

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