Forum Discussion
Solved
File with Multiple JSON doc's - How to Merge them?
Hello: I am working with files that contain multiple JSON doc's. The files look something like this: {"@odata.context":"https://xxxxdev.yyyy.us/contentapi/Facilities/$metadata#Facilities","val...
Hi KBD ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you lbendlin for the prompt response.
You are reading multiple JSON documents (one per line), each with a value array.
Use Document per line in your JSON source to load them.Then apply a Flatten transformation on the value column to extract all items.This will combine all records from each JSON's value array into one dataset.Empty value arrays (like the last line) will be skipped automatically.Thank you.
A standard "expand column" should suffice.
please provide valid JSON responses for both scenarios.