Datatable count

Learn
1

I have a column in DataTabel named Processor ,and I want to count the number of “Processor” having “Snapdragon” string in their name. Any sysntax for that?

ExtractDataTable.Select(“[Processor] Like ‘%Snapdragon%’”).Count
This is working but not giving the exact count

2

Hi @Ritaman_Baral

You can use datatable.select method for that

Processor.Select(“[ColumnName]=‘Snapdragon’”).Length

Please mark as solution if found useful :slight_smile:

Regards
Roshan

3

image
image768×142 8.71 KB

4

Why have you used .Length ?

5

To get the number of rows in that filtered datatable which contains only Snap Dragon

.Select method convert datatable to an array of datarow so basically we are calculating length of array

Regards
Roshan :slight_smile: