79137288

Date: 2024-10-29 12:53:37
Score: 3.5
Natty:
Report link

Do you need something like that?

enter image description here

Would be:

let Kilde = Json.Document(Web.Contents("https://api.statbank.dk/v1/data/FOLK1A JSONSTAT?Tid=2020K1&Tid=2020K2&Tid=2020K3&Tid=2020K4")),#"Konverteret til tabel" = Record.ToTable(Kilde),#"Se Kilde" = Table.FirstN(#"Konverteret til tabel", 1),#"Udvidet Value" = Table.ExpandRecordColumn(#"Konverteret til tabel", "Value", {"dimension", "label", "source", "updated", "value"}, {"Value.dimension", "Value.label", "Value.source", "Value.updated", "Value.value"}),#"Udvidet Value.dimension" = Table.ExpandRecordColumn(#"Udvidet Value", "Value.dimension", {"Tid"}, {"Value.dimension.Tid"}),#"Udvidet Value.dimension.Tid" = Table.ExpandRecordColumn(#"Udvidet Value.dimension", "Value.dimension.Tid", {"label", "category"}, {"Kvartal", "Kategori"}),#"Udvidet Kategori" = Table.ExpandRecordColumn(#"Udvidet Value.dimension.Tid", "Kategori", {"label"}, {"Kategori.label"}),#"Udvidet Kategori.label1" = Table.ExpandRecordColumn(#"Udvidet Kategori", "Kategori.label", {"2020K1", "2020K2", "2020K3", "2020K4"}, {"Kategori.label.2020K1", "Kategori.label.2020K2", "Kategori.label.2020K3", "Kategori.label.2020K4"}),#"Udvidet Value.value1" = Table.ExpandListColumn(#"Udvidet Kategori.label1", "Value.value"),#"Fjernede andre kolonner" = Table.SelectColumns(#"Udvidet Value.value1",{"Kategori.label.2020K1", "Kategori.label.2020K2", "Kategori.label.2020K3", "Kategori.label.2020K4", "Value.source", "Value.value"}),
#"Columnas quitadas" = Table.RemoveColumns(#"Fjernede andre kolonner",{"Value.source"}),
#"Se ha anulado la dinamización de las columnas seleccionadas únicamente." = Table.Unpivot(#"Columnas quitadas", {"Kategori.label.2020K1", "Kategori.label.2020K2", "Kategori.label.2020K3", "Kategori.label.2020K4"}, "Atributo", "Valor"),
#"Columnas reordenadas" = Table.ReorderColumns(#"Se ha anulado la dinamización de las columnas seleccionadas únicamente.",{"Atributo", "Valor", "Value.value"}),
#"Filas ordenadas" = Table.Sort(#"Columnas reordenadas",{{"Valor", Order.Ascending}}) in #"Filas ordenadas"
Reasons:
  • Blacklisted phrase (1): enter image description here
  • Probably link only (1):
  • Long answer (-1):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Low reputation (1):
Posted by: Luis Miguel