Count the "Yes" from excel column

[Gagan_Chaudhari (Gagan)]

Hello,
I have 1 excel file having a column name as ‘Found’ and it has “Yes” and “No” value in it, I need to count the number of “Yes” present in that column.

Thanks

[Sanjit_Pal1 (Sanjit Pal)]

Hey @Gagan_Chaudhari,

You can use filter datatable activity to filter by “Yes” and than you can use count method to count the number of rows.
dt.Rows.Count() this will return you the number of rows available in the datatable.

Thanks,
Sanjit Pal

[fernando_zuluaga]

hey

try this

yourDT.AsEnumerable.Where(function (x) x("Found").ToString.Trim.Equals("Yes")).CopyToDataTable.RowCount.ToString

Regards!

[ushu (Usha kiranmai)]

@Gagan_Chaudhari Use below workflow

Example.zip (9.5 KB)

Input

Output

[saurabh_lawange]

Hey @Gagan_Chaudhari,

you can try following Linq

dt.AsEnumerable.Count(Function(x) x("Found").ToString.ToLower.Trim.Equals("yes"))

Above Linq will Count the rows where Found column has the value as Yes in any case

ToLower - this is used just to handle edge cases, if in case the column contains different versions of YeS*

Thanks,
Saurabh

[nikhil.girish]

Hi @Gagan_Chaudhari we can achieve this using LINQ approach

Let’s say you have read that excel and stored in datatable DT

Now use an assign activity and let variable type be an integer

kindly use below linq query

(From r In DT Where (r("Found").toString.ToLower).equals ("yes") Select r).Count