Need linq query for multiple filter

[supermanPunch (Arpan)]

@Anil_G

FilteredDT = DT.AsEnumerable.Where(Function(x) {“value1”,“value2”}.Any(x(“Column1”).ToString) andAlso Not((“valux”,“valuey”).Any(x(“Column2”).ToString)).CopyToDatatable

@RAKESH_KUMAR_Tiwari ,
I believe there is a correction to be done in ths Query as there is a Function() and {,} missing.

Would recommend you to keep the values in a array or list variables, so that it will be easy debugging in the later stages and easy addition of values to it if required.

Were you not able to implement the previous suggestion ?

Need linq query for multiple filter

Hi @RAKESH_KUMAR_Tiwari , 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 Str…

Also, For Handling errors related to direct CopyToDatatable, you can check the below post :

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…