Output file as JSON array type

Question

Output file as JSON array type

Abhijit Bhadra 91

Suppose i have already transformed JSON file(which is transformed from sql table through dataflow) as below
{"column1" : "A1","row1" : "B1"}
{"column2" : "A2","row2" : "B2"}

Is it possible to get the file as below structure using dataflow
[
{
"column1" : "A1",
"row1" : "B1"
},
{
"column2" : "A2",
"row2" : "B2"
}
]

Answer accepted by question author

0 additional answers

Your answer

Answer 1

MarkKromer-MSFT 5,231 Microsoft Employee Moderator

In data flow, use derived column to create a new column that will hold that structure { column1, row1 }. Let's call it myStruct for now. After the derived column, add an Aggregate transformation. Don't set a group-by in the aggregate and create a new aggregate called myStructs with this expression: collect (myStruct).

Abhijit Bhadra 91 Reputation points

2022-05-13T08:00:11.783+00:00

Hello Mark,

Could you please little elaborate the derived column expression(use derived column to create a new column that will hold that structure { column1, row1 }).
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-05-16T12:49:59.49+00:00

Hi @Abhijit Bhadra ,

As shown below we can create structure in derived column.
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-05-19T15:28:39.143+00:00

Hi @Abhijit Bhadra , Just checking if you get chance to share updates? Please consider hitting Accept Answer button if that helps. Please let us know if any further queries.
Abhijit Bhadra 91 Reputation points

2022-05-20T06:55:21.047+00:00

Hello Maheer,

Above posted issue has been resolved.
first i have transformed data as per required structure as a simple JSON file, then passed the file through copy activity and select "Array of object" in sink, finally got JSON Array type output file.

Thanks for concern.

Share via

Output file as JSON array type

0 additional answers

Your answer