Support Questions

Find answers, ask questions, and share your expertise
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community BlogsRead the Announcement

How to get column value of key in JOLT

avatar
Explorer

I'm looking for breaking following nested JSON file and transform it into a SQL prepared format.

 

Input JSON file:

 

 

 

{
  "Product1": {
    "Purchase": 31
  },
  "Product2": {
    "Purchase": 6213,
    "Cancel": 1988,
    "Change": 3702,
    "Renewal": 5934
  }
}

 

 

 

Desired output: 

 

 

 

[
  {
    "product": "Product1",
    "Purchase": 31
  },
  {
    "product": "Product2",
    "Purchase": 6213,
    "Cancel": 1988,
    "Change": 3702,
    "Renewal": 5934
  }
]

 

 

1 REPLY 1

avatar
Super Guru

 

Hi,

 

Try the following:

 

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "[#2].&",
        "$": "[#2].product"
      }
    }
  }
]

 

If that helps please accept solution.

Thanks