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)
Yes… commands are fix but all 4 commands run for 1st ip then second then third , like this
@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
Did the same, but , i guess, missing something… Thanks Sandeep, let me try it again.