I am using= For each row in data table activity for data table values read from excel sheet
My doubt is for each row in activity current iteration no need to start from first row
Instead of Current iteration start from 5 th row value any formula is there anyone pls help
The idea is to make use of the loop index. You can basically determine the row count & ignore the rows till 5th one. Please find the following workflow:
Test24.xaml (8.7 KB)
Hope this helps,
A possible solution is also to delete the first 5 rows in the data table if you are sure that you always don’t need the data in those specific rows.
Use this code inside for each,
Hope this helps.
Hii @BHUVAN ,
Below is one way how you can do this.
In the property panel of “for each row in Datattable” activity create Index Variable.
Then using if condition You can do the rest of the requirement in the “then” part
Thank you so much @Jithesh_R
Thanks for helping @Suraj_B_Shetty
Thank you so much @arjunshenoy
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.