Read SampleExcel.xlsx and filter the values by employee city (manual input). Count the resulting rows

Dt_Employee.Select(“Employee_City=’+Compare+’”)
Can someone help me figure out whats wrong here?

Try This
Dt_Employee.Select(“Employee_City=’"+Compare+"’”)

Hi,
Try using ‘filter datatable’ activity:

image