FOR EACH ROW IN DATA TABLE DOUBT

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

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.

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.

2 Likes

Hi @BHUVAN

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

Hope this helps.

1 Like

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.

image

Then using if condition You can do the rest of the requirement in the “then” part

image

Regards,

4 Likes

Thank you so much @Jithesh_R :heartbeat:

1 Like

Thanks for helping @Suraj_B_Shetty :heartbeat:

Thank you so much @arjunshenoy :heartbeat:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.