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 Comments
Leave a Reply. |