Write pipeline variable value to csv or text file?

Question

This question was already asked before here: https://social.msdn.microsoft.com/Forums/en-US/929f1bf5-9221-492a-9d7c-44db81b0363e/variable-value-write-to-blob-text-file?forum=AzureDataFactory

But there was no clear answer and the person who asked the question did not follow up on the question.

I have a pipeline variable. Is there a way to write the value of this variable (either string of array) to a csv/text file? The link above suggests using data flow,but how?

Answer 1

Below thread has a workaround given by Kranthi where Copy activity > source > additional column setting is used to export variable value to file.

https://stackoverflow.com/questions/60673220/transfer-the-output-of-set-variable-activity-into-a-json-file-azure-data-fact

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav