Forum Discussion
Solved
Import JSON from web to Excel - needing assistance
Hello Community, I am trying to help out a colleague of mine. She has a JSON from the web that she wants to import into Excel to analyze the data. She found that we can import from JSON on the we...
You try to load all sections of JSON file into the one table. Actually different sections (more exactly with different structure) shall go into separate table. In attached they are for Gross Charges and for Inpatient Payer Specific Charge (all sections since they have the same structure).
After that perhaps you need to merge them to make final transformation, but that require knowledge of business logic, what is the data is structured and what we'd like to have in result.
Jschm001 , you are welcome