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

Question

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 ?

question from:https://stackoverflow.com/questions/66061511/how-to-read-csv-file-data-line-by-line-in-azure-data-factory-and-store-it-in-a-v

Answer 1

You can follow these steps:

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

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

HTH.