Forum Discussion
Import JSON from web to Excel - needing assistance
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.
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