Hello guys i have used a for each row data table and created a variable to get the rowindex.
The condition in if activity satisfy it will in add 1 to rowindex and break the for each and should move to the next row.
problem:-
it is taking the next row data after break activity but the row index is not adding it is still 0 for the next row data also.
so is there any solution for this.
@Gokul_Murali
For the activity ‘For Each Row’, when you set the variable for Index, it’ll automatically increase by 1 after finishing one iteration.
Just remove the assign to check the message box.
i removed the assign activity still index is zero but it is moving to the next row.
I have used a break activity in if condition under for each is it because of that.
But i created a variable Rowindex in foreach activity it is already coming as “0”
RowIndex will increase only after completing that Body sequence. As you are breaking it in middle, it’s not getting increase.
I’m not sure what you are trying to achieve but if you want to process first row of the datable, you can use dt.Rows(0)
Have you tested with Continue instead of Break? Break will exit the For loop. If you need to continue the next row, you should use Contiune.
See i have an excel
if the remarks contain “Document attached successfully in dms” , it should go to the next row and and the index should be “1”
i have also used the same code but the row index is not increasing after break activity.
Use Continue then try debug the process. You’ll see what the robot is doing.
I changed the break with continue the problem is that row index is increasing but the row data is not looping it is showing only first data
The updated data is in your row variable. E.g. your If condition should be:
row("Remarks").ToString.Contains("Document Attached Successfully in DMS")
Yeah i made changes like that even after the row index is not increasing but is moving to the next row data
Would you provide the screenshot of your updated workflow?
Use this workflow. You don’t need to increase the RowIndex manually.
DataTableIteration.xaml (9.9 KB)
Code:
Output:
Thanks,
Ashok
Thank you somuch bro
