flatten json data

arkiboys 9,706 Reputation points
2022-03-13T22:49:42.733+00:00

sample json data:
...
"parcels": [
{
"name": "kljkl",
"state": "fgfgf",
"quantities": [
{
"planned": "ertet",
"uom": "poui"
},
{
"actual": "7ttyty",
"uom": "qwqw"
}
],
...
As you see in the screenshots below, the first flatten, (flatten12) has the parent which is parcels.
When I use the second flatten (flatten13) to get the inside array of parcels which is called quantities, I select from drop down the parcels.quantities
Questions:
1- should the drop down show quantities rather than parcels.quantities?
2- I get this error when trying to preview flatten13: screenshot below

182554-image.png

182586-image.png

182564-image.png

182603-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

1 answer

Sort by: Most helpful
  1. arkiboys 9,706 Reputation points
    2022-03-15T06:14:50.2+00:00

    solved.
    thank you


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.