Counting specific row

[Kelvin1 (Kelvin)]

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?

[Yoichi]

HI,

Can you try the following expression?

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

Sample20221125-3.zip (2.4 KB)

Regards,

[Kelvin1 (Kelvin)]

Hi @Yoichi i tried the solution that u gave to me. But it give me error like this

Why the uipath read my datatype as a double?

[Yoichi]

Hi,

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

Regards,

[Kelvin1 (Kelvin)]

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

[Kelvin1 (Kelvin)]

like this @Yoichi

[Yoichi]

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,

[Kelvin1 (Kelvin)]

Hi @Yoichi its work! thank u sir