Need linq query for multiple filter


Maybe we could make use of Contains and Not Contains method within the Linq to filter the rows. As you have the list of values to be filtered, let us consider the below :

list1 = {"Approval and coding","Comment request","Receiving Resolution","170 verification procees for PO Invoice"}
list2 = {"Agata Panek(APKNEK)","Alex Lee(ALLE7)","Alexander Fenn(AFENN)","Ali Hayder","Tokay(ATOKAY)","Alia Salameh(ASALAME1)"}

Here, list1 and list2 are variables of type Array of String.

Next for the Linq Expression we can use the below :

FilteredDT = DT.AsEnumerable.Where(Function(x)list1.Contains(x("Column1").ToString) andAlso Not(list2.Contains(x("Column2").ToString)).CopyToDatatable

Here, FilteredDT is the Datatable variable which contains the Filtered values and DT is the Input datatable.

Let us know if the above method is understandable and if you were able to achieve the required output.