Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,996 questions
Hi @arkiboys , I think if you use the same source Dataset as SINK, it will work. Thanks!
re-save the .json file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
arkiboys
9,696
Reputation points
Hello,
I read a json file i.e. xyz123.json from gen2 storage
Then in dataflow I edit the content.
How can I re-save the file in it's original location and name?
Thanks
Accepted answer
-
Nasreen Akter 10,801 Reputation points2022-03-21T17:35:04.86+00:00 -
arkiboys 9,696 Reputation points
2022-03-21T18:01:42.04+00:00 I tried that already but it does not.
Initially I save the .json file using sink in copy activity and I pass parameter to have the name of the saved .json file.
Then in dataflow I take the content of that json file and then use derived column to replace values inside the json data.
Then using sink in dataflow I pass the name of the file into parameter but the name does not seem to have any effect and so random name is generated.
in dataflow sink, I am using a different folderpath but note that I am passing the name and I do not understand why it generates random name rather than the name I am giving it in parameter of dataset number 2 -
Nasreen Akter 10,801 Reputation points
2022-03-21T18:30:22.66+00:00 @arkiboys , if you have the filename, then you can pass it to the Dataflow as a parameter and then use it in the SINK-->Settings -->Output to single file --> add the filename-PARAM by using the dynamic content.
Sign in to comment -