Retrieve data from excel and filter column

Learn Academy Feedback
1

Hi,
I have created excel doc and converted to .csv.Suppose there is column called score,I want to perform filter on it(say score>50) and retrieve it,but I am getting column name score not found error,eventhough I checked Include Column Name.
What should I do?

2

@Rashmi_Maliger There is syntax error

Try this once Assign = yourdatable.Select(“score>50”)

Refer attached file Filter.zip (2.2 KB)

3

Hi @indra,
I referred to your attached file. When i try to do it in my project. There is an error showing under for each row:
Value of type -1-dimensional array of System.Data.datarow’ cannot be converted to ‘system.data.datatable.’.
However my variabble types are filiteredRow is DataRow and dt is DataTable which is the same as your above attached file.

1 Like
4

system.datarow is the TypeArgument in for each. can you please check

6

Hi
Below video on data table filter

Below is about data table select

Both will help you