I am trying to find count of a column values based on other column conditions, basically something similar to countif. e.g. if I have a data table “Dt1” C1 C2 C3 a y 3 a n 3 a y 3 a y 3 b y 2 b y 2 d n 0 So i want count of Column1 in Column3 base…

we can calculate by calculate by group by or by filtering check orig data - dtData prepare an empty datatable with buld datatatable having the 3 cols C1,C2,C3 - dtResult Assign activity Left: dtResult Right: (From d in dtData Group d by k=d(“C1”).toString.Trim into grp=Group Let c = grp.Wher…

How to obtain the count value of any column in uipath based on condition

Help Studio

ppr (Peter Preuss) September 17, 2021, 12:16pm 11

Topic		Replies	Views
How to take the the particular column data count with some specific keyword Help studio	5	1055	January 8, 2019
Count the number of records satisfying a particular condition Help	2	6718	September 12, 2017
How to find count of a value? Studio	11	2711	August 3, 2021
DATATABLE with 4,00,000 records and need count based on conditions Help activities , studio	5	2315	July 31, 2019
Count items in column Help	18	2667	April 14, 2019

How to obtain the count value of any column in uipath based on condition

Related topics