How can i check the number of row = some number

Learning Hub Academy Feedback
, ,
1

Hi All
pleae need your Support , i have CSV sheet and i want to check the number of Row if equel 96 that mean this sheet have all the data if not that mean there is data missing how i can check and what the condition for that

thanks all for support

Screenshot
Screenshot1439×759 46.5 KB

2

Read the csv file as a text file. The output will be in string.
if string.contains("Total 96 Records") then "contains all data" else "missing"

3

thanks dear for replay @KarthikByggari
please if you have xaml can you send to me because i’m new in uipath

4

get count .xaml (6.5 KB)
@KarthikByggari

could you check my xaml this is right

5

Or you can read all the data starting at A10 (with Read Range activity), store the data on a datatable and use dtTable.rows.count to return the numbers of rows stored :smiley:

6

as i know Read Range activity not working with CSV i tried but it’s give me error and i need the sustem to check if the number of rows =96 then complete the process if not i will let the system send email to inform me there is data missing

7

Try to use like this:

image

Regards,

8

i trid but not working and give me error

any other idea
to help me

9

Try what I’ve show above :slight_smile:

10

but this will give me Row count

if i want menthin if this count = number then complete if not stop and send email

how should be

11

Is it possible to send me the .csv file so I can do a example for you? :slight_smile:

12

get count .xaml (6.5 KB)

this my XAML but the system can’t accept to upload CSV

13

Try to zip the file :slight_smile:

14

Test.zip (6.9 KB)

15

Here’s the example.

Hope you understand :slight_smile:

get count .xaml (11.1 KB)

Regards,

16

hi dear
@Lucas.Pimenta
but how you let read rang work with CSV sheet because now it’s not working with me