Counting specific row

Help Community
,
1

So guys i have a excel with 2 column that is “Name” and “Email” like this
Name Email
John John@gmail.com
Doe Doe@gmail.com
Kelvin

I want to count the row that doesnt have email, how to do that?

2

HI,

Can you try the following expression?

image

dt.AsEnumerable.Count(Function(r) String.IsNullOrEmpty(r("Email").ToString))

Sample20221125-3.zip (2.4 KB)

Regards,

3

Hi @Yoichi i tried the solution that u gave to me. But it give me error like this
image
Why the uipath read my datatype as a double?

4

Hi,

Can you share screenshot of your activity which is set the above expression?

Regards,

5

Im using it for Append line activity @Yoichi is it possible?

6

image

like this @Yoichi

7

Hi,

Can you try to add .ToStrng at the end of the expression as the following?

dt.AsEnumerable.Count(Function(r) String.IsNullOrEmpty(r("Email").ToString)).ToString

Regards,

8

Hi @Yoichi its work! thank u sir

1 Like
9

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