re-save .json file

arkiboys 9,646 Reputation points

In dataflow:
source points to csv dataset which is looking at a .json file
dataset column delimeter and row delimeters are set to no delimiter.
source datapreview shows all the json data in Column_1
derived column does a replace function of a texts in column_1
derivedcolumn2 does another replace function of a text in column_1
sink lands the data into a .json dataset but the issue is that this new .json file has Column_1 at the beginning and alot of backslashes.
How can it be changed to json format when it was at source, i.e. same as the initial source screenshot?
The final screenshot shows you the problem

Hope it helps

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

Accepted answer
  1. Nasreen Akter 10,761 Reputation points

    Hi @arkiboys ,

    Please create the Source and SINK dataset as Delimited Text Type with the configuration below. It should solve the issue. Thank you!


0 additional answers

Sort by: Most helpful