Hi All, i want to write linq query to filter below item for column name ( [image]) Approval and coding Comment request Receiving Resolution 170 verification procees for PO Invoice And again one more filter in different column same file column Name - (Responsible User) i need to exclude below …

let say, i have below data. [image] i want to exclude some values from Responsible column if that names exists, again i want to select few Values like Comment Request etc… in Queue Column i think this is very straight forward, i am one who is creating confusion here sorry for that. i can use try…

@RAKESH_KUMAR_Tiwari Please check this.To make it clear I have just re written the same formula FilteredDT = DT.AsEnumerable.Where(Function(x) {"value1","value2"}.Any(x("Column1").ToString) andAlso Not({"valux","valuey"}.Any(x("Column2").ToString)).CopyToDatatable Here value1 value2 valuex value …

[image] RAKESH_KUMAR_Tiwari: some values from Responsible column i [image] RAKESH_KUMAR_Tiwari: again i want to select few Values like Comment Request etc… in Queue Column @RAKESH_KUMAR_Tiwari , The some/few values mentioned are the values that you should be knowing beforehand if I’m …

ok, let me try then update you, but before that i got one small issue, actually bot writing the extarcted data in excel but everything as text, but i want it should convert to Number in (Amount) column only for everytime when bot runs again and extratct the data. [image] how to achieve it

@RAKESH_KUMAR_Tiwari In your extract datatable wizard choose …column type as number instead of text Cheers

@RAKESH_KUMAR_Tiwari Table settings would have it…easier way is to use extract datatable again and in the wizard you can select from dropdown cheers

[image] RAKESH_KUMAR_Tiwari: actually bot writing the extarcted data in excel but everything as text @RAKESH_KUMAR_Tiwari , Maybe for this, If you do already know the Column order in the table, we should be able to create a Excel Template having the columns names in the required format, mean…

i am trying format cell activity , it is just deleting all the data, img for ref [image] i have given range G2:G500, so everytime G2 will not have 500 range, but for saftey purpose i have provided, since it doesn’t have 500 range so throwing error, how to handle dynamically

[image] RAKESH_KUMAR_Tiwari: [image] image1076×426 17.4 KB @RAKESH_KUMAR_Tiwari , Maybe you have specified wrongly. It must be G2:G500, Try this and let us know, Also maybe try with G:G

Need linq query for multiple filter

Help Activities

RAKESH_KUMAR_Tiwari (RAKESH KUMAR Tiwari) April 21, 2023, 11:28am 14

i want to change only one column that is Amount.

which propert will have that option

Topic		Replies	Views
How to multiple filter apply in excel using linq Activities excel , activities , question	5	86	September 23, 2024
Deleting rows from a sheet after filtering Help excel	34	7754	March 28, 2018
Linq to filter data Studio datatable , excel , uiautomation , pdf , orchestrator , robot , activities , studio , data_scraping , studiox , question , activities_panel , linq , linq-query , linq-quey	18	1877	August 29, 2022
How to filter value using query instead of filter data table Studio excel , studio , question	7	1301	February 7, 2023
Using if condition need to filter out and extract that filter data into another sheet in excel Activities excel , activities , question	15	1738	April 4, 2021

Need linq query for multiple filter

Related topics