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

Need Jolt Spec to convert matrix json to denormalized json formart

avatar

Can anyone please help me a JOLT spec to convert my matrix type json to denormalized json. Please find the below my input json and my expected josn output.

Input Json:

[
  {
    "attributes": [
      {
        "name": "brand",
        "value": "Patriot Lighting"
      },
      {
        "name": "color",
        "value": "Chrome"
      },
      {
        "name": "price",
        "value": "49.97 USD"
      }
    ]
  },
  {
    "attributes": [
      {
        "name": "brand",
        "value": "Masterforce"
      },
      {
        "name": "color",
        "value": "Green"
      },
      {
        "name": "price",
        "value": "99.0 USD"
      }
    ]
  }
]

Expected Json output:

[
    {
      "brand": "Patriot Lighting",
      "color": "Chrome",
      "price": "49.97 USD"
    },
    {
      "brand": "Masterforce",
      "color": "Green",
      "price": "99.0 USD"
    }
  ]

I was trying to build JOLT spec to convert this json. But challenge is the json which I have multiple tables with "attributes" tag.

 

@Json @NIFIJOLT 

Thanks in advance!

1 ACCEPTED SOLUTION

avatar
New Contributor

[
{
"operation": "shift",
"spec": {
"*": {
"attributes": {
"*": {
"@(0,value)": "attributes[#4].@(0,name)"
}
}
}
}
}
]

View solution in original post

2 REPLIES 2

avatar
New Contributor

[
{
"operation": "shift",
"spec": {
"*": {
"attributes": {
"*": {
"@(0,value)": "attributes[#4].@(0,name)"
}
}
}
}
}
]

avatar

@NIFIJOLT This is working as I expected. Thank you so much!!!