Need To check array (filenames)value contains in datatable(scrapped data)

Help Activities
1

Hello All.
I need a solution for this
I am having file names which is in Array of string
I want to check that those file names is present in datatable column ?

2

Hi @Nilay_Adate ,

Could you check with the below Expression :

fileNames.All(Function(a)DT.AsEnumerable.Select(Function(x)x("YourColumnName").ToString).ToArray.Contains(a))

Here, fileNames is your array containing file names, DT is the input datatable.

1 Like