Forum Discussion
Solved
splitting multi value column in query editor
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?
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"
1 Reply
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"