I have a datable which contains three columns, Column one is a list of date in which, I need to check it’s contents if it matches with all of the items in an array. For example Array Contains {1,2,3} DataTable Column One Contains{1,2,3,4,5,6} I want to filter out the Datatable where to row with v…

[image] RGT: Column one is a list of date in which, I need to check it’s contents if it matches with all of the items in an array Hi @RGT , We would require to know How the formats of Date are appearing in both the Array and in the Datatable. This is required to Convert it to a Proper DateT…

I always convert them first to Short Date String. They all start from string so I do Convert.toDateTime(var).ToShortDateString

@RGT , Could you try the below Expression : arrayRow = DT.AsEnumerable.Where(Function(x)Not(dateArray.Any(Function(y)CDate(y)=CDate(x("YourDateColumn").ToString)))).ToArray here arrayRow is a variable of Type Array of DataRow, and DT is the Input Datatable, dateArray is a variable of Type Array of…

Remove data row if the value cannot be find in an array

Help Studio

ppr (Peter Preuss) April 28, 2022, 10:59am 5

let us know more details on the datatable. Just share the immediate panel result for:
YourDataTableVar

Have a look here on how to do:

Topic		Replies	Views
Removing Rows from a datatable where the Value is in an array Studio datatable , studio	5	2877	August 24, 2020
Remove DataRows from Datatable which is not in the array Help	5	947	May 26, 2019
Remove rows where a column doesnt containt the elements in an array Activities datatable , excel , activities , question	5	1386	December 28, 2021
How to retain rows from Datatable which does not contain any of the variables in an array Studio datatable , linq	5	992	February 16, 2023
Matching an array and data table Studio studio , question , activities_panel	9	1563	April 24, 2022

Remove data row if the value cannot be find in an array

Related topics