Select item in datatable

Learn
9

@Maroua302

check if one column of my datatable contains for example the name “john”

can be interpretated in many directions:

  • True if any row contains John in columnA
    dtData.AsEnumerable.Any(Function (x) x(“ColumnA”).toString.Contains(“John”))

*return all john rows
dtData.AsEnumerable.Where(Function (x) x(“ColumnA”).toString.Contains(“John”)).toList
dtData.Select(“[Name] LIKE ‘%john%’”).toList

About the datarows and Copytodatatable:
we can also expect that a filter result can be empty. A copytodatatble would fail
So for this case we let us return list of Datatrows drResult
and in an if activity we do check:drResult.Count > 0
True. dtResult = drResult.CopytoDatatable

Let us know your feedback
If it is not working share some sample data and more detail result definition with us
Thanks

Did you tried Filter DataTable? Any feedback on this from your end?

2 Likes