Forum Discussion

WillY_OneEyed's avatar
WillY_OneEyed
New Member
3 years ago
Solved

A column with Records and Lists

Hi Folks, I'm trying append all LIST register.   The code is here:   let Paginas = (Page) => let Source = Json.Document( Web.Contents("http://api.worldbank.org", [Headers ...
Need Help
  • ThxAlot's avatar
    ThxAlot
    3 years ago

     

    Make it simple,

     

    let
    Source = List.Accumulate(
        {1..6},
        {},
        (s,c) => s & Json.Document(Web.Contents("http://api.worldbank.org/v2/country?format=json&page=" & Number.ToText(c))){1}
    ),
    #"Table From Records" = Table.FromRecords(Source)
in
    #"Table From Records"

     

     

     

AlienSx's avatar
AlienSx
Super User
3 years ago

Hi, WillY_OneEyed if you want to select lists only and combine them then 

List.Combine(Table.SelectRows(#"Expanded Column1", (x) => x[Column1] is list)[Column1])