foreach - range function

arkiboys 9,686 Reputation points
2022-04-25T08:25:17.24+00:00

for each activity iterates 93 times as there are 93 items in array1...
using the @Rover function, @Rover (0,10) it iterates from the first item to the 10th one by reading the items from the array1
I do not see how it iterates through the next batch in the array1. i.e. 11 to 20?
should foreach do this automatically or is there something for me to do to keep iterating in batches of 10
Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,121 questions
0 comments No comments
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 32,011 Reputation points Microsoft Employee
    2022-04-27T09:10:24.103+00:00

    Hi @arkiboys ,
    Thankyou for using Microsoft Q&A platform and thanks for posting your query.
    As I understand your ask, it seems you want to know after passing start and end value to the range , how would the pipeline determine the value inside range function for the upcoming iterations. Please let me know if my understanding about your query is wrong.

    Range function generates an array of integers starting from a certain number up to the defined length. For example: @Rover (3,4) would return [3,4,5,6].

    ADF will not auto-determine the start and end value for the next iteration. Either you need to pass the hardcoded value or dynamically generate the values for the next iterations as covered in this thread

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful