LINQ on DataTable at Code stage, raise exceeption

Help Forum
3

we can do this within an assign activity, doing a check on int base and can handle defensive the empty filterresult as mentionend by @Yoichi

LHS: Result | DataType: List(Of DataRow) =

(from myRow in dtData.AsEnumerable()
where CInt(myRow("Amount").toString.Trim) > 1000
select r = myRow).toList

then check within an if acitvity
Result.Count > 0
Then: dtResult = Result.CopyToDataTable
Else: dtResult = dtData.Clone

In case of Int conversion issues we can add some handlings on non parseable Amount values as well

1 Like