dataflow - no sink

arkiboys 9,646 Reputation points

dataflow1 returns fields in a select activity (Field1 which has multiple distinct values) and so there is no sink
dataflow2 expects is to loop through each of the values from dataflow1
Here is what I have but I get an error when trying to debug:
dataflow1 --> no sink found

How do I do this please?
Thank you

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

Accepted answer
  1. Nasreen Akter 10,761 Reputation points

    Hi @arkiboys ,

    I would suggest to write/sink Dataflow1 output to a file ( the file could be save in a temporary/staging storageContainer). Then in the pipeline, if you want to pass 1 value at a time, read the file with a lookup activity --> then foreach loop, pass it to the second dataflow. If you want to read all the values, then read the file as a source in the Dataflow2. Hope this helps, thanks!

0 additional answers

Sort by: Most helpful