How to stroe values in setvariable and use in another activity using Azure datafactory?

Ashok Kumar Bollineni 46 Reputation points
2021-02-05T13:07:01.907+00:00

Hi All,

I have a serial No column in my file, i should store it in setvariable squentially and i want to use that value in another activity. Requesting you to suggested how can i achieve it?

Regards,
Ashok

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,793 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nasreen Akter 10,766 Reputation points
    2021-02-05T15:09:16.38+00:00

    Hi @Ashok Kumar Bollineni ,

    In the Azure Data Factory pipeline, you can have a LookupActivity --> ForEach Activity --> Set Variable + other Activity. Please see the screenshot for details. Thanks!

    64564-excelfile.jpg
    64517-dataset.jpg
    64607-pipeline-1.jpg
    64565-pipeline-2.jpg
    64608-pipeline-3.jpg
    64618-pipeline-4.jpg

    ----------

    If the above response is helpful, please accept as answer and upvote it. Thanks!

    0 comments No comments