How find combined count rows and columns in datatable?

Help Studio
, ,
1

how find combined count rows and columns in datatable?

The image is a table displaying purchase order details including the unit, item code, vendor, purchase order number, purchase order date, and corresponding month. (Captioned by AI)
The image is a table displaying purchase order details including the unit, item code, vendor, purchase order number, purchase order date, and corresponding month. (Captioned by AI)594×692 19.5 KB

above mentioned our datatable i need combined out put for month and unit column below mentioned our template datatable i have already creat it table
A table lists various unit names and months from May to December, including a Grand Total column highlighted in red, with all cells currently empty. (Captioned by AI)
A table lists various unit names and months from May to December, including a Grand Total column highlighted in red, with all cells currently empty. (Captioned by AI)869×415 6.08 KB

kindly share work flow…

2

Hello @domsmgtmeet22

You could perhaps use the “Select” parameter on the datatable to grab the requested fields.

Datatable.Select("[Unit]='KCH' And [Month]='May'").CopyToDatatable.Rows.Count

Regards
Soren

3

i need group count update my template datatable

4

How to Group by and Count Data in a DataTable and Populate a Template in UiPath?

5

@domsmgtmeet22

You can use groupby to get count if each geoup

Dt.AsEnumerable.GroupBy(function(x) x("ColumnToGroupOn").ToString).Select(function(x) newdt.LoadDataRow({x.Key,x.Count},False)

Here newdt contains teo columns first the key column with string and second count with int datatypes

This given count for each group which can then be written as you need in the dattable

You can group on multiple columns as well if needed

Cheers