Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
dataflow foreach
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
arkiboys
9,706
Reputation points
1-
In the pipeline, I use a foreach loop activity to read the list of tables from a .csv file to load from on-prem to blobstorage.
2-
For each of the tables, some of the table fields need to have expressions applied to its field value in the dataflow.
I notice that there is no foreach inside the dataflow. How can I achieve this?
Thank you
Azure Synapse Analytics
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator2021-10-19T04:23:19.747+00:00 Hi @arkiboys ,
Thanks for using Microsoft Q&A forum and posting your query. As this is a duplicate of this thread - https://learn.microsoft.com/en-us/answers/questions/594374/dataflow-foreach-activity.html we are redirecting thread to other one.
Sign in to comment
Sign in to answer