Group data in datatable and count amount of data

[nuttapong_ludloy (AoFnonymous)]

if have data in datatable

How 2 Group data in output result same sample picture.

[max_maharana]

hi nuttapong_ludloy

Can u elaborate your scenario ?
U can take the reference from :

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

[Ajju (Ajjayya Hiremath)]

hello @nuttapong_ludloy

if you want group based on the column, by using the below expression you will get the Each column based in the column

DataTable.Columns(“ColumnName”) - pass column name in this expression you will get the values

Regards
Ajay

[Sukesh_V (Sukesh Vanarasi)]

Need more elaboration in this case.

[nuttapong_ludloy (AoFnonymous)]

DataTable in Scenario

1.Group in Column “MonthYear” and count
2.Count by Condition “Expire_year in each MonthYear” and count

Thanks All for Know how.