I have a excel sheet that has 20+ Columns,I want to apply filter on multiple columns so I am trying a select query in Assign .
I simply tried as Read Range -> Output : DT
DT = DT.Select(“Industry LIKE ‘Utilities’”).CopyToDataTable()
It gives me error as The Source contains no data rows, Can someone please help .
I have verified the Column Name its Industry and I want to pick rows that contains the word Utilities only .