Hi, I am having a table with format PO cus 1 aa 1 ef 2 wer 22 fds 4 bb and list PO_list = (3,2,66,1) I need to delete all rows which contains values from list.

@Katerina_Chabova Check below post for your reference [image] Filter data table wizard with array /List Studio Hi , my question how can you use the filter data table wizard with array or list? [image] I have a column “workercode” and i want to filter that column base…

Hi @Katerina_Chabova Please try this, Datatable variable name - dt List variable name - PO_list Query to remove rows based on list dt.asenumerable.where(function(d) not PO_list.any(function(x) x.tostring.equals(d.tostring))).copytodatatable Thanks

It is not working, It just show entire table, filter doesn’t work. Shouldn’t there by any specific column from table, which is used for filtering?

I tried this (From r In datatable.AsEnumerable From s In list where r(0).tostring.Contains(s) Select r).CopyToDataTable I need the exact opposite of this. Somehow combine the not contains function

PLEASE TRY THIS dt.asenumerable.where(function(d) not PO_list.any(function(x) x.tostring.equals(d(“PO”).tostring))).copytodatatable

PO_list = {3,2,66,1} assign activity: LHS: Result | DataType: List(Of DataRow) RHS: From d in dtData.AsEnumerable Where Not PO_List.Any(Function (x) x.toString.Equals(d(0).toString.Trim)) Select r=d).toList then check within an if acitvity Result.Count > 0 Then: dtResult = Result.CopyToDataTa…

I’ve got error in if statement: Job stopped with an unexpected exit code: 0xE0434352, Exception Type: System.Exception

A hint of excel issue [image] Job stopped with an unexpected exit code: 0xE0434352 Knowledge Base Users with excel workflows accessing large amounts of data will encounter this error "Job stopped with an unexpected exit code: 0xE0434352", from time to time. Follow the belo…

OK I used Clear data table, but now it show me this error the source contains a detached datarow that cannot be copied to the datatable

please share a screenshot of this part implementation. thanks

Delete rows in datatable based on values in list

Help Activities

Srini84 (Srinivas Kadamati) November 24, 2021, 2:23pm 2

@Katerina_Chabova

Check below post for your reference

Hope this may help you

Thanks

Topic		Replies	Views
Filter datatable - Help Activities excel , activities , question	4	900	December 21, 2022
Can i use list of array in filter data table Values? To check OR condition? Activities excel , activities , question	29	5917	June 1, 2022
How to remove rows using filter data table with variable inside the filter data table Activities excel , activities , question	7	1787	July 14, 2022
Filter datatable not using if or for each Studio studio , question , workflow_diff	2	389	July 19, 2023
How to delete/remove rows from a datatable based on a List using Linq Studio	2	1031	March 1, 2023

Delete rows in datatable based on values in list

Related topics