FOR EACH ROW IN DATA TABLE DOUBT

[BHUVAN]

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

[arjunshenoy]

Hi @BHUVAN

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,
Best Regards.

[Ninjabullen]

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.

[Suraj_B_Shetty (Suraj)]

Hi @BHUVAN

Use this code inside for each,
dt_Input.Select().Skip(5).CopyToDataTable()

Hope this helps.

[Jithesh_R (Jithesh Karkera)]

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

Regards,

[BHUVAN]

Thank you so much @Jithesh_R

[BHUVAN]

Thanks for helping @Suraj_B_Shetty

[BHUVAN]

Thank you so much @arjunshenoy