Forum Discussion
Extracting values causes duplication
Why are you expecting 72 records? NOTE a Record has a special meaning in Power Query as it's a data structure so I assume you mean rows of data.
That JSON shows 5 data points per response so I'm assuming each list in the Timestamps and Values column contains these. Extracting the data in the ists will giev you as many rows as there is data.
What is your expected final result/what does the table look like at the end?
Regards
Phil
Sorry if I am not making sense, I think I would expect 730 rows in actuality. So when I expand the timestamps column, it brings out 730 rows which is correct based on the fact that there is chronological hourly timeline.
However, I have noticed when expanding the results.data.values, it then duplicates it
There should only be one data value for each timestamp but now get multiple duplicate values which isn't right. When I use a visualisation on this dataset, I then just get a solid static line which of course isn't accurate.
Any ideas, appreciate the response 🙂