Hi @Sreejith_lal
Try as below
Variables.CreateNewDatatable InputTable: { ^['type'], [$'''WI2'''], [$'''WI2'''], [$'''CI2'''], [$'''CI2'''] } DataTable=> DataTable
Scripting.RunDotNetScript Language: System.DotNetActionLanguageType.VisualBasic ReferenceRootPath: $'''D:\\assemblies''' Script: $'''outDatatable = inDatatable.AsEnumerable().
Where(Function(r) r.Field(Of String)(\"type\") = \"WI2\").
CopyToDataTable()''' @'name:inDatatable': DataTable @'type:inDatatable': $'''Datatable''' @'direction:inDatatable': $'''In''' @'name:outDatatable': $'''''' @'type:outDatatable': $'''Datatable''' @'direction:outDatatable': $'''Out''' @outDatatable=> outDatatable
Linq Query to select the type column where it has WI2
outDatatable = inDatatable.AsEnumerable().
Where(Function(r) r.Field(Of String)("type") = "WI2").
CopyToDataTable()
Above linq query will filter all the rows of column type as WI2 and output to a datatable, so you need to have a out direction of outDatatable with Datatable as type
Let me know any other errors you are facing
If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Cheers,
Srini
