re-save .json file

arkiboys 9,646 Reputation points
2022-03-21T20:35:26.797+00:00

Hello,
In dataflow:
1-
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
2-
derived column does a replace function of a texts in column_1
3-
derivedcolumn2 does another replace function of a text in column_1
4-
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
    2022-03-22T01:55:33.453+00:00

    Hi @arkiboys ,

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

    185405-image.png


0 additional answers

Sort by: Most helpful