how to capture output of append variable in adf and write to json or csv file in adls

Raviyaramati-1837 1 Reputation point
2021-07-12T15:56:07.46+00:00

i have a set up like below , i need to capture data from for each activity to json or csv

113964-image.png

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

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 43,602 Reputation points Microsoft Employee
    2021-07-13T07:26:20.42+00:00

    Hi @Raviyaramati-1837 ,

    Welcome to Microsoft Q&A forum and thanks for posting your query.

    One way to achieve this requirement is by utilizing "Add additional columns during copy" feature as explained in this stackoverflow thread - [Transfer the output of 'Set Variable' activity into a json file Azure Data Factory

    After your append variable activity, have a subsequent Copy activity and define a column and pass the value of append variable as described in stackoverflow thread.

    Hope this info helps. Do let us know if you have further query.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.