@rankifyhc as @Dave has mentioned a LINQ statement can help.
Use an assign activity
to: yourDataTableFilteredVar
Value: YourDataTableVar.AsEnumerable.Where(function ( r ) r(“Line Desc”).ToLower.Equals(“cloud solution”)).CopyToDataTable
Make Sure:
- there will be rows after filtering, otherwise an exception is thrown.
- AsEnumerable is not a member of 'System.Data.Datatable' - #2 by loginerror