solved.
thank you
flatten json data
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