How to run two loops one after other one without break

#1

I have one excel file with two excel sheets . “Sheet1” contains ‘IP address’ and “Sheet2” contains ‘Commands’. I need to take the IP address one by one and run all commands for every IP, that means each IP will run all 4 command, same like others. How to loop it please help. Attached the sample excel file. Test.xlsx (8.9 KB)

#2

As per your excel, can you please confirm whether the commands will be same? @khan

#3

Yes… commands are fix but all 4 commands run for 1st ip then second then third , like this

#4

@khan
You can use read range activity to read both sheet and store in 2 different datatable.
Then use for each activity to iterates ip datatable under this use another for each activity to read command from another datatable
Thanks

3 Likes
#5

Did the same, but , i guess, missing something… Thanks Sandeep, let me try it again.

#6

This would do the trick absolutely @khan

1 Like