Support > Forums > OpenBots Studio > How to get number of particular values in a rows in datatable?

How to get number of particular values in a rows in datatable?

Harshita Aralikatte Ramesh

  • Reporter
  • Calender Icon January 24,2023 at 8:28 PM

I have a column in my excel called Verified. I want to calculate number of yes in the column and add that variable while sending an email. How to do this?

This forum has 317 topics, 687 replies, and was last updated 4 months ago by Nataly Alvarado...

Harshita Aralik...

  • Participant
  • Calender Icon January 25,2023 at 5:39 PM

Perfect thank you :)

Rushabh Arbat

  • Participant
  • Calender Icon January 25,2023 at 12:54 PM

Hi Harshita Aralikatte Ramesh,

Thank you for sharing query.

As per your use case we suggest you the easiest way would be to use the filter DataTable command it filters a row from dataTable and store in new dataTable after that by using Get DataRow Count command, you get total count of Particular value (Ex "Yes"). As well as the another alternative way is, you can use for loop or Linq.

Thanks

You are not authorized to reply, please click here to login and add your reply to this topic.