Capture Set variable Output in a file

Question

Capture Set variable Output in a file

Shivam Ramola 71

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,256 Reputation points Microsoft Employee Moderator

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.

Answer accepted by question author

0 additional answers

Your answer

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

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.

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

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

Shivam Ramola 71 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 36,716 Reputation points MVP Volunteer Moderator

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

Share via

Capture Set variable Output in a file

0 additional answers

Your answer