CODEWITHSUNDEEP
csvazure-data-factory
SHIVAM YADAV
SHIVAM YADAV

Reputation: 65

How to read csv file data line by line in Azure Data Factory and store it in a variable

I want to read a csv file line by line and store that value in variable so that i can pass that in for each activity in Azure data factory.

So I want to read records line by line and store each record in a variable so that we can pass in for each activity one by one and generate new data based on these records.

How can we achive this ?

Upvotes: 0

Views: 3889

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

You can follow these steps:

  1. Lookup active to get the data of the csv data. enter image description here
  2. Foreach the csv rows. enter image description here
  3. In Foreach active, set the row value to the variable. enter image description here
  4. Build your active after the variable, for example: enter image description here

If you have any other concerns, please feel free to let me know.

HTH.

Upvotes: 1

Related Questions