Select method is not wording for filtering data Table, Please let me Know any another way or solution

[chinnapureddy03 (Chinnapu Reddy)]

Hi , I have Excel data with Columns Name Like “EmpId, Name, Age, Department, Salary, Location”. reference use clicks below Image.

I want to get Data, whose Department is HR. But When I’m using the Select method, Getting error. Please resolve this

[hkjobs1988 (Hitshs Kumar)]

Hi @chinnapureddy03

Check if this works for you

Filtred_DT=Your_DT.AsEnumerable().Where(Function(row) row(“Coulmn Name of DT”).ToString=“txt toFilter”).CopyToDataTable()

Below is a related post

How to Filter Data Table

hey @ClaytonM Thank you for response , attaching the scrubbed result from the targeted page , just changing the customer details for data security TPA Policies extraction.xlsx (26.4 KB)

[Chand (Chandani Dave)]

This is not working for me. Do we have to import something here ?

[indra]

@Chand wt error u r getting

[loginerror (Maciej Kuźmicz)]

Hi @Chand,

Try this syntax:
dt_Emp.Select(“[Department]='”+Filter+“'”)

or simpler:

dt_Emp.Select(“[Department]=‘HR’”)

[Chand (Chandani Dave)]

it worked. thanks

[ChinnapuReddy]

Hello @loginerror
this is not working for me Let see my images

.

Based upon filter value , I want get result as shown in image 3.

@hkjobs1988,

Please can you explain your code

[Vivek_Arunagiri]

Provide 07 within single Quote as ‘07’ and try

[ChinnapuReddy]

same issue, Can’t find the column

[ChinnapuReddy]

Hello,

I tried one more method , That is also not working to me . Let see below images you will get idea. Please let me know any have alternate method or excel macro codes.

[Vivek_Arunagiri]

Please check if there is any space in column header “Division”.

[Chilli_Sarangi]

Hello Guys,

Please someone help me as the filter fuction is not working properly foe me as well.