Re: How to split json subarrays and keep root

2020-09-29 Thread Jens M. Kofoed
Hi Matt Thank you very much for pointing me to the ForkRecord. After playing around with it I got to work. kind regards Jens Den man. 28. sep. 2020 kl. 23.37 skrev Matt Burgess : > Jens, > > Try ForkRecord [1] with "Mode" set to "Extract" and "Include Parent > Fields" set to "true", I think

Re: How to split json subarrays and keep root

2020-09-28 Thread Matt Burgess
Jens, Try ForkRecord [1] with "Mode" set to "Extract" and "Include Parent Fields" set to "true", I think that does what you're looking to do. Regards, Matt [1]

How to split json subarrays and keep root

2020-09-24 Thread Jens M. Kofoed
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