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