Hi,
I need to implement an ETL using Azure Data Factory. Can someone help me out here?
Use Case:
1. Read data from SQL server using Lookup activity.
2. Use a For Each loop to iterate through each row and call a web service that helps with the transformation of data and returns transformed data.
3. Now I need to append each of these rows with the transformed data and write them into a CSV file.
I have completed the first 2 steps. Stuck in 3rd part.
Can someone help me out on how to create a CSV file after the transformation? Or I welcome if anyone has a better approach to this.
Thanks in advance.