Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Doubt about changing format of JSON

Hi, 

I'm receiving some JSON data in this format: 

 

{
    "paging": {
        "pageIndex": 1,
        "pageSize": 100,
        "total": 1
    },
    "measures": [
        {
            "metric": "A",
            "history": [
                {
                    "date": "2019-04-23T20:56:48+0000",
                    "value": "15"
                }
            ]
        },
        {
            "metric": "B",
            "history": [
                {
                    "date": "2019-04-23T20:56:48+0000",
                    "value": "1.0"
                }
            ]
        }
    ]
}

What I'd like to obtain is another JSON with the date (which is the same for all the metrics that I'm going to take) and, then, the metrics with their values this format (some kind of denormalizing the data related to metrics in order to get the pairs "metric_name":"metric_value").

{
"date":"2019-04-23T20:56:48+0000", "A": "15","B": "1.0"...// and all other metrics }

 Is there any Talend component with which I can take this output or similar?

Labels (3)
0 Replies