i want delete rows from the Data table…while looping through
This article might be helpful to you.
I am having a excel in format
Now I want to delete all the row where Status=“PV”.
Please suggest a solution. I want to perform this action using one database table only.
We won’t able to delete the rows while looping as it would through target of invocation error
But still we can store the row index in a list(of int32) variable so that once after the loop we can use a separate loop to delete those rows
Here you go with an example
Yah the expression is fine but we cannot use REMOVE DATAROW ACTIVITY inside thr for each row loop as we are currently iterating through each row in the datatable and meanwhile we won’t bale to delete the rows in it and that why Ymir’s was showing that error.
So we need to get the row index now using add to collections activity and use a separate for each loop activity and pass the variable used in the add to collections- as input here in for each loop activity and then use remove datarow activi…