I am trying to get the CIMS_Distinct_Count ( encircled in blue ) by selecting the columns Batch_Date and OPCO_NAME (Highlighted in Yellow) .
I tried reading the range of this excel file into a datatable (dtUC4Report) and tried to filter it (dtUC4ReportFiltered) like this.
Assign dtUC4ReportFiltered = dtUC4Report.Select(“Convert([Column3], ‘System.String’) like '%”+ in_strBatchDateTime + “%’ and [Column7] = '”+ in_strOpcoName +"’").CopyToDataTable
But it won’t work as I am having error Assign: The source contains no DataRows.
Can someone help me see what might be the mistake I am making and what causes the error?
Please bear with me as I am stuck in this scenario for a while now.
Thanks a lot in advance.