Filter data table wizard with array /List

Hi , my question how can you use the filter data table wizard with array or list?

I have a column “workercode” and i want to filter that column based on a array called code.

@noe.ngongo

welcome to the forum

give try on following and use within an assign activity following:

(From r in yourDataTableVar.AsEnumerable
From s In yourFilterTokenArrayVar
Where r(“workercode”).toString.Contains(s)
Select r).CopyToDataTable

1 Like

You Can not directly use an array or list inside the filter wizard. But you can achieve this using linq-
dtInputData.AsEnumerable().where(Function(s) code.Any(function(t) s(“Status”).tostring.Contains(t))).FirstOrDefault()

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.