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?
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?
HI,
Can you try the following expression?
dt.AsEnumerable.Count(Function(r) String.IsNullOrEmpty(r("Email").ToString))
Sample20221125-3.zip (2.4 KB)
Regards,
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?
Hi,
Can you share screenshot of your activity which is set the above expression?
Regards,
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,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.