Need linq query for multiple filter

[RAKESH_KUMAR_Tiwari]

ok, that’s done, it’s working fine now.

pls check the below error

Also pls let me know if person is not already there in most of the reports then it will work right? Also for some case below item is not available in column, so, irrespective of any information bot should work. is that possible right with UiPath.

[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…

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

Please change this (“valux”,“valuey”) to {“valux”,“valuey”}

cheers

[RAKESH_KUMAR_Tiwari]

Hi @supermanPunch ,

can you pls check, why these enteris also coming after filtering.

[supermanPunch (Arpan)]

@Anil_G

filter_dt.AsEnumerable.Where(Function(x) {“Approval and Coding”,“Comment Request”,“Receiving Resolution”,“170 verification procees for PO Invoice”}.Any(x(“Queue”).ToString) andAlso Not {“Agata Panek(APKNEK)”,“Alex Lee(ALLE7)”, “Alexander Fenn(AFENN)”, “Ali Hayder Tokay(ATOKAY)”, “Alia Salameh (ASALAME1)”, “Alessandera Luceri (ALUCERI)”}.Any(x(“Responsible User”).ToString)). CopyToDatatable

@Anil_G, The anonymous function is missing as already mentioned.

The Updated Expression should be the below :

filter_dt.AsEnumerable.Where(Function(x) {"Approval and Coding","Comment Request","Receiving Resolution","170 verification procees for PO Invoice"}.Any(Function(y)y.Equals(x("Queue").ToString)) andAlso Not {"Agata Panek(APKNEK)","Alex Lee(ALLE7)", "Alexander Fenn(AFENN)", "Ali Hayder Tokay(ATOKAY)", "Alia Salameh (ASALAME1)", "Alessandera Luceri (ALUCERI)"}.Any(Function(y)y.Equals(x("Responsible User").ToString))).CopyToDatatable

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

Please do use the above expression mentioned by @supermanPunch

i have remoced the updated comment as well as there are more syntax errors in it

Cheers

[RAKESH_KUMAR_Tiwari]

Hi @supermanPunch ,

can you pls check , why it is filtering which is not requiored also? img for refernce

i need to filter below one that’s it.
Approval and coding
Comment request
Receiving Resolution
170 verification procees for PO Invoice

one more thing i observed , i filtered the data and write the data in different sheet than it is working fine, but when i try to write the data in same sheet where i filtered it, it is not filtering properly, you can refer the above img.

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

When you are writing to same sheet…it would work as expecyed but you need to first clear the sheet so that only nee data is present or else old data where rows are not being written again will be retained

Please chekc the same…you can clear or delete old sheet and recreate the same again

And if youw ant the file to be checked…please provide a sample input and output files so that we can recreate and check

Cheers

[RAKESH_KUMAR_Tiwari]

shared, personnely to you

[RAKESH_KUMAR_Tiwari]

just one question, no need to put for each loop right?

i reading the data storing in dt, using assign and filtering the data and writing the same in write range

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

No Need to use for loop

And if on excel then I tried like below and it is filtering properly

RakeshFilter.xaml (9.2 KB)

cheers