Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, pretty much new here, tried searching for an aswer for this. I got query from http://api.bitcoincharts.com/v1/weighted_prices.json and it gives me a table like one in the picture. I would like column values to separate by columns keeping headers 7- 30 and 24h,
What did I miss, I keep getting errors when trying to unpivot/split?
Solved! Go to Solution.
The timestamp value can't be expanded, so I would suggest to delete it.
let Source = Json.Document(Web.Contents("http://api.bitcoincharts.com/v1/weighted_prices.json")), #"Converted to Table" = Record.ToTable(Source), #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Value] <> 1511644685)), #"Expanded Value" = Table.ExpandRecordColumn(#"Filtered Rows", "Value", {"7d", "30d", "24h"}, {"7d", "30d", "24h"}) in #"Expanded Value"
The timestamp value can't be expanded, so I would suggest to delete it.
let Source = Json.Document(Web.Contents("http://api.bitcoincharts.com/v1/weighted_prices.json")), #"Converted to Table" = Record.ToTable(Source), #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Value] <> 1511644685)), #"Expanded Value" = Table.ExpandRecordColumn(#"Filtered Rows", "Value", {"7d", "30d", "24h"}, {"7d", "30d", "24h"}) in #"Expanded Value"
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |