Dec 31 2020 07:21 AM - edited Jan 04 2021 06:21 AM
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 web. Personally, I have never worked with a JSON file before (and no one else in my organization has enough experience with Excel) so I thought I would give it a try. I went through and watched several tutorial videos and read files on how to do it.
I followed the steps and I feel like there is a lot more data that I am missing (I could be wrong). I attached the Excel spreadsheet on what I have and have a bunch of fields that come up as null. Is this correct or am I missing information?
Any suggestions would be greatly appreciated.
Jan 02 2021 07:31 AM
SolutionYou 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.
Jan 04 2021 06:20 AM
Jan 04 2021 10:07 AM
@Jschm001 , you are welcome
Jan 02 2021 07:31 AM
SolutionYou 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.