Datatable merge and get count on basis of this

Help
, ,
1

New Bitmap Image (2)
New Bitmap Image (2)1920×1080 281 KB

hello freinds, i am working on re framework configured for datatable. so what my task is i have to count the no the subject in which the kid is pass

2

Hi @amit_joshi

You can use Select method to get the count

DataTable.Select("[ColumnName] = ’ “+ValueToFilter+” ’ ").CopyToDataTable.Rows.Count.ToString

Cheers :slight_smile:

3

am
Actually what i am trying to achieve is this like i have common emp id and name based on that i want to find out how many subject he is pass like in example.

4

Can you send me your dummy excel file??

5

amit big.xlsx (9.0 KB)

6

Whether you tried without the linq query???

7

no,actually i am not getting any logic for this type.

8

@amit_joshi

Check this :point_down:

9

This output is okay for you which I have got from my workflow,
amit_output.xlsx (8.8 KB)
and the workflow,
SampleSequence.xaml (19.5 KB)