Forum Discussion

nes_k4's avatar
nes_k4
Copper Contributor
Dec 03, 2021
Solved

Download two tables from web in one function query

Hello, I wanted to ask if it's possible to download two tables from a list of URLs in one single query? Please refer to the attached file. I have a list of URLs for different stock codes. At the mom...
Excel for web
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 03, 2021

    nes_k4 Change the applied step in fxOther where you initially filter one table to this:

    #"Filtered Rows" = Table.SelectRows(Source, each ([Id] = "cnhk-list" or [Id] = "cnhk-list2")),

     Now the function will load both tables and create one bigger table.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 03, 2021

nes_k4 Change the applied step in fxOther where you initially filter one table to this:

#"Filtered Rows" = Table.SelectRows(Source, each ([Id] = "cnhk-list" or [Id] = "cnhk-list2")),

 Now the function will load both tables and create one bigger table.

  • nes_k4's avatar
    nes_k4
    Copper Contributor
    Dec 04, 2021
    Thank you so much for your help again!
    I got another question please. I want to download the same data tables but in a different language. Below is the link to the site (basically the same website but in a different language):
    http://www.aastocks.com/tc/stocks/analysis/company-fundamental/profit-loss?symbol=00001
    I used the same queries but the download time is very slow. It took more than 2 hours, whereas the English version only took 10-15 min.
    I was wondering if there're any technical issues relating to this?
    Thanks again for your help!
      • nes_k4's avatar
        nes_k4
        Copper Contributor
        Dec 05, 2021

        Riny_van_Eekelencould I please ask another question?

        I want to download tables "Regular advisers" and "One-time advisers" in one query from the below website:

        https://webb-site.com/dbpub/advisers.asp?p=488

        How should I amend the below codes that are currently picking up "Regular advisers" only?

         

        let
        Source = Web.Page(Web.Contents("https://webb-site.com/dbpub/advisers.asp?p=488")),
        Data0 = Source{0}[Data],
        #"Promoted Headers" = Table.PromoteHeaders(Data0, [PromoteAllScalars=true]),
        #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Adviser", type text}, {"Role", type text}, {"Added", type date}, {"Removed", type date}})
        in
        #"Changed Type"

         

        Thank you so much for your help!

Resources