Writing hierarchy from derived column to JSON sink without column name Azure Dataflow-CodePudding

I am creating a derived column to create JSON structure in Azure Dataflow to write it into a JSON sink. I called the hierarchy complex column "orders" so when the derived column is written to JSON sink every JSON object is an "orders" object.

[enter image description here][1]

How could I remove the "orders" container so the final JSON structure is only a set of JSON obects without the "orders" structure.

This is the final JSON sink after being written in Azure DataFlow:

{
    "orders": {
        "customer": {
            "ordering": {
                "customer_account": "4226010"
            }
        },
        "order_id": "802202100000100100A"
    }
}

I would like it like this :

    {
    "customer": {
        "ordering": {
            "customer_account": "4226010"
        }
    },
    "order_id": "802202100000100100A"
}

CodePudding user response：

In the Derived Column transformation, define the structure as you have in the 2nd example above. Create a new column called "customer" and in the Expression box in Expression Builder, click on the curly braces for the current customer structure in Expression Values.