Forum Discussion
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 moment I've set up two queries to download two separate tables from the same web page.
I was wondering besides using Append Queries, is there any way to set up just one single function query in the beginning to capture both tables in one go?
Any help and insight is much appreciated.
Thank you!
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.
7 Replies
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.
- 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 That I don't really know. Sorry!
