Lookup vs foreach activity

Anshal 2,251 Reputation points
2022-07-01T07:53:27.443+00:00

Hi friends iam still confused about when and what situation I use lookup and foreach two looking same help me please

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

Accepted answer
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2022-07-01T11:07:56.81+00:00

    Hi @Anshal ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question.

    As I understand your query, you want to know the difference between the usage of LookUp and ForEach Activity. Please let me know if my understanding about your query is incorrect.

    LookUp activity returns the data in the form of an array from the dataset you provide whereas ForEach Activity takes array as the input and iterate over each item of the array to perform action .

    Check the following documentation to know about LookUp activity and ForEach Activity

    Kindly refer to the following video to get more details:
    LookUp activity
    ForEach activity

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.