I have a collection variable and i want to remove from the datatable

I have a set of data in the list variable (Listvariable) and I want to remove those data’s from datatable so how to achieve that by using vb.net linq query method


Assign activity:
dataTable = (From row In dataTable.AsEnumerable()
Where Not listVariable.Contains(row(“Column_Name”).ToString())
Select row).CopyToDataTable()

1 Like

im getting error like this [Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled]

But later it is working how?

ensure that all doublequotes are of type: " and not inverted

cant understand so could you please show same sample?


try rebuilding the Assign activity by removing it and then adding it back with the same expression. Sometimes, re-creating an activity can resolve issues related to expressions.
Close and reopen UiPath Studio. Sometimes, restarting the application can resolve temporary issues related to compiling expressions.



(From d In YourDataTableVar.AsEnumerable()
Where Not YourCollectionVar.Contains(d("Column_Name").ToString().Trim())
Select r = d).CopyToDataTable()
1 Like

Thanks for the helping

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