Hi
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
