Dear @aksh1yadav and @Mr_JDavey
I want to delete the row where Variable match is found
tried below following by for each loop and Remove Activity, if I pass value manually it is working fine but not working with variable, please help
It will just create a new datatable with results where no match will be there. so you can use that datatable for your further operation.
if you wanna delete rows then there is post already exist by me, so search it
If you will read all post in this thread above you can get your approach and idea.
you can instead of delete much rows take only those data which is needful for next step so just check your idea from above existing post and get the actual context and if still face any prob let me know.
Solution Without Usign for each:
Datatable result = DT1.AsEnumerable().Where(function(row) Not DT2.AsEnumerable().Select(function(r) r.Field(Of Int32)("Contractorid")).Any(function(x) x = row.Field(Of Int32)("empid"))).CopyToDataTable()