Multi-Dimensional Json file to Table

Srikala — Wed, 08 Nov 2017 10:42:09 GMT

Can anyone help me with this json file scenario?

I have a folder with multiple json files having the same structure. Each json file has some columns having single value whereas some other columns have list values(list- value) pair. Want to generate a report that has data from all the files in this folder.

I started by taking a single JSON file, transformed the list columns of it into separate tables....making each of it as a separate query( I added an index column). So for a single json file, apart from the source I have multiple queries corresponding to tables. Relationships are also set between all of these queries.

How do I generate a tabular report with source columns and also include the list column names in it,.... corresponding to a master record, there are multiple list values. I am not able to get the values of the list in the report.

Can anyone suggest me how to proceed?

Also I plan to append the queries of the rest of the json files to these, is that the right approach?

Thanks

Re: Multi-Dimensional Json file to Table

Eric_Zhang — Thu, 09 Nov 2017 06:37:20 GMT

@Srikala

Could you share some JSON sample files in your case?

topic Multi-Dimensional Json file to Table in Developer

Multi-Dimensional Json file to Table

Re: Multi-Dimensional Json file to Table