Capture Set variable Output in a file

Shivam Ramola 66

I have used 2 variables with array data type to store the values of a database table name
the first variable is pointing to set variable and the other one is pointing to append variable.
Now these value needed to be stored in file in storage account

Could you please guide on how to store these values in a file.

svijay-MSFT 5,201 Reputation points Microsoft Employee

2021-09-22T16:11:52.917+00:00

Hello @Shivam Ramola ,
Just checking in to see if the below answer provided by @Nandan Hegde helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Accepted answer

Nandan Hegde 29,886 Reputation points MVP

2021-09-17T08:57:59.247+00:00

hey,
you can refer the below link:
https://stackoverflow.com/questions/60673220/transfer-the-output-of-set-variable-activity-into-a-json-file-azure-data-fact
Please sign in to rate this answer.
Shivam Ramola 66 Reputation points

2021-09-20T09:25:54.633+00:00

Thanks for your answer.
I have gone through this but is there a way to put the data in a csv file.

Nandan Hegde 29,886 Reputation points MVP

2021-09-20T09:28:26.46+00:00

Hey,
Instead of JSON dataset, you need to select delimited dataset. Thats the only change in sink.

Please accept it as answer in case if it resolved your query as it may benefit other community members as well.

Thanks
Sign in to comment

Capture Set variable Output in a file

0 additional answers