Datatable count

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

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

Why have you used .Length ?

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: