The code you provided looks very promising indeed and I think that we came much closer to finding a solution here. PS: I already checked out the forum post ( Nested JSON and never end Records), but unfortunately the advice given there didn't help me to solve the above-mentioned problem.įirst of all I want to thank you for taking the time to look into my problem. I would be very happy if you could help me! Thanks in advance! Is there a way to extract the values from all columns so that the dataset still has 158 rows (which corresponds to the number of projects)? Can the values from the columns "Countries", "Entities", "Disbursements", "Funding" and "ResultAreas" simply be expanded to new columns instead of rows (to avoid duplication of the data)? Such a double counting must not be, because then I can no longer work with the values in the dataset. The problem occured when I tried to expand the columns "Countries", "Entities", "Disbursements", "Funding" and "ResultAreas", the values in the rows to the left of these columns are copied down - when I expanded everything I got 109256 rows. I managed to view the basic information about the 158 projects that are contained in the JSON file by transforming the list to a table and then expanding the other columns. I am desperately trying to parse the data from a nested JSON file (that has many records and lists in it) to Excel.
0 kommentar(er)
