Hello, I want to get count of rows as per Status updated in Excel file in column. I have different status in one column and want to get count against that status. Below is my Excel file data [image] From this data I want to get 3 counts (1st 2 able to get, challenge is for only 3rd) Total N…

@nilesh.mahajan please try this dt.AsEnumerable.Count(function(x) x("Status").ToString.Equals("Not Printed") OrElse x("Status").ToString.Equals("Report not found Message")) if values are not exact then try contains instead of equals cheers

How to get Row count from Data table with multiple status (Conditions)

Help Studio Web

system (system) Closed March 10, 2025, 7:15am 3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Count the Total number of values in Excel Column Studio datatable , excel , studio , question , workflow_diff , activities_panel	5	805	November 10, 2022
Comparing sheets Help excel , activities	4	1828	October 29, 2018
How to get the value count in particular Row Activities excel , activities , question	6	1197	February 25, 2023
I have to show how many rows in excel are excuted successfully and how many rows are remaining to execute in log message in catch block Activities activities , question , document_processing	5	1114	May 4, 2022
Excel -Count lines with condition Studio excel , question	11	1374	March 23, 2020

How to get Row count from Data table with multiple status (Conditions)

Related topics