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

Help Activities
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