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

@sathish_Kumar6

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?

@sathish_Kumar6

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.

inverted
grafik

corrected:

(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.