Data table 2

Help
1

Hi Guys,

Need to count employee name as RAM belongs to account department.Below is the snip of my excel.

image

2

Hi Nitin,

you can use linq query to filter data if data is present in Data table.
use assing activity and use Datatable.select(“[Name] = ‘Ram’ and [DepartmentName] = ‘Accounts’”) which will give array of data rows or “Filter Data Table” activity also you can use to filter it. after that you can get rows count by using Datatable.rows.count method.

Regards,
Vijay.

3

@Nitin2606

In assign activity, Replace DT with your datatable name.

int_count = DT.select("Name='Ram' and DepartmentName='Accounts'").rows.count

4

@Vijay_Kumar_Cthanks

5

@ranjithThanks

1 Like
6

@Nitin2606 Welcome :slight_smile:

7

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