Rows.count.ToString

Help Activities
, , ,
1

I want to count the total number of rows enetered in csv but when it print,it only shows half rows

2

Hi @Cuberoot

Try writing the dt into another cav and check if there are missing rows and validate what happened wrong in your worflow before doing count

Cheers

3

I think in count it removes the duplicate name,so what should I do

4

Hi @Cuberoot

What do you mean by it removes duplicate name?

Cheers

5

HI @Cuberoot

Do you have remove the duplicate value before getting the count?

6

some users used different software with the same name

7

Hi @Cuberoot

Ideally it will read all… if you are filtering on something then you need to give correct rules. Can you show screenshot of what you want and what is happening in file

Cheers

8

HI @Cuberoot

Can you give us more details on the issue?

To getting the row count just use Dt.Rows.Count

Regards
Gokul

9

Hi @Cuberoot
This might be caused by a blank row in your data.
Check the CSV file and see if you have an empty row.

10

Actually, I want to extract the users who have used the software’s for the last 24 hours.If I count manually, it is 182 but when I used dt.rows.count,to string in log it prints=91

11

@Cuberoot From where you are extracting the users?and check the excel sheet has all users which was extracted.

12

yes.I has extracted all the users

13

Hi @Cuberoot

Are you doing any filtering on dt after reading? .

Or in your excel are the formatting of few cells different?

How are you reading excel and after read do a count a check if its peoper

Cheers

14

Can you show the excel sheet with data?