Hi

I have a JSON document with an array which I would like to split and
flatten.
In my example below key4 is an array containing 2 documents. I need to
split the record based on each document in the key4 array, so I end up with
multiple records. Where each new record has a copy of all keys except key4
which should be flatten into each own document.
{
key1:value1,
key2:value2,
key3: {
  key3a:value3a,
  key3b:value3b
}
key4: [
   {
      key4a1:value4a1,
      key4a2:value4a2
  },
  {
      key4b1:value4b1,
      key4b2:value4b2
  }
]
}

Should be like this:
Record 1
{
key1:value1,
key2:value2,
key3: {
  key3a:value3a,
  key3b:value3b
}
key4:{
   key4a1:value4a1,
   key4a2:value4a2
  }
}

Record 2
{
key1:value1,
key2:value2,
key3: {
  key3a:value3a,
  key3b:value3b
}
key4:{
   key4b1:value4b1,
   key4b2:value4b2
  }
}

Kind regards
Jens M. Kofoed

Reply via email to