Coping filter data from data table

Getting error source contains no data rows. I have complete data file.
Assign : copyDT.Select("[GOL]=‘Mini Gupta’").CopyToDataTable

this error comes from an empty filterresult. For issue analysis just check in excel in the GOL column

  • if rows with Mini Gupta are present
  • if rows with Mini Gupta and an additional blank before or after present (would explain the empty result)

For handling this case you can do following

Assing: drLeader = copyDT.Select("[GOL]=‘Mini Gupta’").toList
drLeader is of datatype List

use an if activity to check rows are available: drLeader .Count > 0
then: Leader = drLeader.CopyToDataTable
else: Leader = copyDT.Clone

1 Like