How do I get the count of specific value in a column?

Help Activities
, ,
1

Hey All,

I have a column “Remarks” with 10 rows.

8 Cells with the Value “Success” and 2 with “Failed”.

How do I get the count of these two values ?

Thanks,
Uio

2

HI @uio
whether the value is only “Success” and “Failed”?

if yes you can use

CountSucess=dt_Input.AsEnumerable.Where(Function(x) x("Remarks").ToString.Equals("Succes")).Count

CountFailed=dt_Input.AsEnumerable.Where(Function(x) x("Remarks").ToString.Equals("Failed")).Count
1 Like
3

@uio

Assign activity:
successCount = yourDataTable.AsEnumerable().Count(Function(row) row.Field(Of String)("Remarks") = "Success")

Assign activity:
failedCount = yourDataTable.AsEnumerable().Count(Function(row) row.Field(Of String)("Remarks") = "Failed")
1 Like
4

Hi @uio

Try this:

SuccessCount=DT.AsEnumerable().Where(Function(row) row.Field(Of String)("Remarks") = "Success").Count()
FailedCount=DT.AsEnumerable().Where(Function(row) row.Field(Of String)("Remarks") = "Failed").Count()

image
image900×788 40.3 KB

Input:

image

Output:

image

Cheers!!

5

Hi @uio

Read Range (Excel file) -> dt

Assign successCount = 0
Assign failureCount = 0

For Each Row in dt
   If row("Remarks").ToString = "Success"
      Assign successCount = successCount + 1
   Else If row("Remarks").ToString = "Failed"
      Assign failureCount = failureCount + 1

Log Message: "Success Count: " + successCount.ToString
Log Message: "Failure Count: " + failureCount.ToString
6

Hi @uio

successCount = (From row In dataTable.AsEnumerable()
                               Where row.Field(Of String)("Remarks") = "Success"
                               Select row).Count()

failedCount = (From row In dataTable.AsEnumerable()
                              Where row.Field(Of String)("Remarks") = "Failed"
                              Select row).Count()

successCount and failedCount is of DataType System.Int32.

Hope it helps!!

7

you can use filter datatable activity with filter condition as “Remarks”=“failed”

the output of which is a datatable…and dt.rows.count will give the count of the failed rows

8

I get an error stating “asenumerable is not a member of system.data.datatable”. Tried adding “System.Data.DataSetExtensions” as said in AsEnumerable is not a member of 'System.Data.Datatable', nothing’s changed.

Somebody please help me with this.

9

can you share screenshot how you use it?

10

Hi @uio

Try this:

SuccessCount = DT.AsEnumerable.Count(Function(x) x("Remarks").ToString.ToLower.Equals("success"))

FailedCount = DT.AsEnumerable.Count(Function(x) x("Remarks").ToString.ToLower.Equals("failed"))

image
image883×277 14.1 KB

Hope it will helps you :slight_smile:
Cheers!!