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 lik...
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"